count the number of fields that was selected by user

[n1ef5ng1]

Hi i would like to come out with a table only if user filter 3 or more fields, i cant hard code it by getselected count as there are 50 over fields.

count(if((wildmatch(GetCurrentSelections(),'*')), 1))

i tried something like above but it only show me as 1 if i choose any of the field. 0 show 0 , 1 show 1 , 2 show 1.

can i make it that it will sum them up?

[n1ef5ng1]

count((wildmatch(GetCurrentSelections(),'*')))

output is the same

[jonathandienst]

I suggest using:

=Alt(SubStringCount(GetCurrentSelections(), ':'), 0)

Use Alt so you get 0 when nothing is selected

[jonathandienst · Accepted solution]

Reading your post more carefully: use this in the conditional show:

=SubStringCount(GetCurrentSelections(), ':') >= 3

[n1ef5ng1]

i have a qn, why : and not *

[jonathandienst]

Because : is the default separator between the field name and the selections. So there is one : per field and we are counting that. There are no * in the GetCurrentSelections(), so there is not point in counting that.