Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Or, something like:
For number of fields:
SubStringCount( GetCurrentSelections(':', ',', '@', 100), ':')+1
For number of values:
=SubStringCount( GetCurrentSelections(',', ',','@', 100), ',')-SubStringCount( GetCurrentSelections(':', ',','@', 100), ':')
Try this
=rangesum($(=concat( 'GetSelectedCount([' & FieldValue('$Field', ValueLoop(1, $(=FieldValueCount('$Field')))) & '])',',')))
sillytricksdepartment
something like this?
Or, something like:
For number of fields:
SubStringCount( GetCurrentSelections(':', ',', '@', 100), ':')+1
For number of values:
=SubStringCount( GetCurrentSelections(',', ',','@', 100), ',')-SubStringCount( GetCurrentSelections(':', ',','@', 100), ':')
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...
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.
Absolutely! Important catch.
Yes, that did the trick thanks