Forum Discussion

GeorgeKhairalla's avatar
GeorgeKhairalla
Qrew Cadet
9 years ago

Trying to ""Count"" the number of selections in a multi-select text field

Hi, I have a multi-select text field : [ERP Products] I'm trying to have a Formula - Numeric field, to count the number of products that were selected. I have tried something like this: ...
Formulas and functions
Tables and fields
KevinBoyle's avatar
KevinBoyle
Qrew Trainee
6 years ago
Sorry for the delay. I have just copied the formula that you have shared above and changed the multi select field to the field in my app...

var text value = ToText([Caller Needs, Interests, Drivers]);
Sum(
ToNumber(Trim(Part($value,1,";"))),
ToNumber(Trim(Part($value,2,";"))),
ToNumber(Trim(Part($value,3,";"))),
ToNumber(Trim(Part($value,4,";"))),
ToNumber(Trim(Part($value,5,";"))),
ToNumber(Trim(Part($value,6,";"))),
ToNumber(Trim(Part($value,7,";"))),
ToNumber(Trim(Part($value,8,";"))),
ToNumber(Trim(Part($value,9,";"))),
ToNumber(Trim(Part($value,10,";"))),
ToNumber(Trim(Part($value,11,";"))),
ToNumber(Trim(Part($value,12,";"))),
ToNumber(Trim(Part($value,13,";"))),
ToNumber(Trim(Part($value,14,";"))),
ToNumber(Trim(Part($value,15,";"))),
ToNumber(Trim(Part($value,16,";"))),
ToNumber(Trim(Part($value,17,";"))),
ToNumber(Trim(Part($value,18,";"))),
ToNumber(Trim(Part($value,19,";"))),
ToNumber(Trim(Part($value,20,";")))
)

I have this in formula numeric field and trying to hopefully get a pie graph out of the data.
FadyIbrahim's avatar
FadyIbrahim
Qrew Member
6 years ago
Hi, I am trying this out but am getting a Syntax Error: Extra characters beyond the end of the formula. I copied the formula below. I am a bit of an amateur so forgive any silly mistakes. Any ideas? 

New_variable = ToText();
Sum(
ToNumber(Trim(Part($value,1,";"))),
ToNumber(Trim(Part($value,2,";"))),
ToNumber(Trim(Part($value,3,";"))),
ToNumber(Trim(Part($value,4,";"))),
ToNumber(Trim(Part($value,5,";"))),
ToNumber(Trim(Part($value,6,";")))
)

------------------------------
Fady Ibrahim
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    not tested but try this.
    If there is a syntax error please post the your formula and the whole error message.

    var text value = ToText();

    Count(
    Trim(Part($value,1,";"))<>"",
    Trim(Part($value,2,";"))<>"",
    Trim(Part($value,3,";"))<>"",
    Trim(Part($value,4,";"))<>"",
    Trim(Part($value,5,";"))<>"",
    Trim(Part($value,5,";"))<>"")





    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • CourtneahThomas's avatar
      CourtneahThomas
      Qrew Member
      4 years ago
      Hello Mark,

      I just have a quick question on this formula.  Where do I put that formula?  Inside the summary report?  On the form in the multi-select formula field?

      ------------------------------
      Courtneah Thomas
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        You would create a new formula numeric field to calculate the count.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------