Forum Discussion

GeorgeKhairalla's avatar
GeorgeKhairalla
Qrew Cadet
10 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
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
try this

var text value = ToText([Product Add-On Apps]);
Count(
Trim(Part($value,1,";"))<>"",
Trim(Part($value,2,";"))<>"",
Trim(Part($value,3,";"))<>"",
etc etc


Trim(Part($value,20,";"))<>"")

------------------------------
Mark Shnier (YQC)
[email protected]
------------------------------
GeorgeKhairalla's avatar
GeorgeKhairalla
Qrew Cadet
4 years ago
Hm. I don't think that made a difference.   Still seems to be picking up the empty values.

As a side note, I'm not sure understand the  meaning of Trim(expression) <> ""  ... is this a shorthand for my "If" statement?

If(Trim(Part($value,1,";")) <> "", Trim(Part($value,1,";")),"")

------------------------------
George Khairallah
CTO
gotomyerp, LLC
------------------------------