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:

var Numeric ERPCounter = List(",",ToText[ERP Products]));   // to get the text list of the products, then have a "," delimited, so that the next (Count) function would work.

Then used:

Count($ERPCounter)

That doesn't seem to be working.

Trying to find a way to count those products. Any ideas?

Thanks!