Count of Current Selections

[Anonymous]

HI Guys,

I need a function that counts all selections of de current selection box;

Example

Year : 2016

DIM 1 : X

DIM 2: Y

DIM 3: Z

Count  = 4 selections

Any idea's?

Best regards,

Robbie

[Gysbert_Wassenaar]

Try this

=rangesum($(=concat( 'GetSelectedCount([' & FieldValue('$Field', ValueLoop(1, $(=FieldValueCount('$Field')))) & '])',',')))

sillytricksdepartment‌

[Anonymous]

something like this?

Chart with count of $Field values

[tresesco · Accepted solution]

Or, something like:

For number of fields:

SubStringCount( GetCurrentSelections(':', ',', '@', 100), ':')+1

For number of values:

=SubStringCount( GetCurrentSelections(',', ',','@', 100), ',')-SubStringCount( GetCurrentSelections(':', ',','@', 100), ':')

sillytricksdepartment

[Anonymous]

Hi Gysbert,

Thanks for your reply but I think my question was not clear enough.

It's not the count of the values of the fields, Its the count of the selections: Year+DIM1+DIM2+DIM3 makes 4...

[Gysbert_Wassenaar]

That's a lot saner than my attempt. You may want to add the Maxvalues parameter though. The default is six. If you have more than six selections in a field the total count will be off.

[tresesco]

Absolutely! Important catch.

[Anonymous]

Yes, that did the trick thanks