Set Analysis with Multiple GetFieldSelection

[Vimarsh]

Hi folks,

I am trying to create an expression which should count all the records based on the values selected in the filter panel.

I have a variable which stores field selections as

varName=GetFieldSelections(AgencyName)

My expression is:

COUNT({1<AgencyName={"$(varName)"}>}Status)

This expression works perfectly fine when only single value is selected in the AgencyName filter. The expression fails when multiple values are selected. Any ideas how to solve this?

Thanks in advance!

[sunny_talwar · Accepted solution]

Try this instead

Count({1<AgencyName = p(AgencyName)>} Status)

[sunny_talwar]

or this

Count({1<AgencyName = $::AgencyName>} Status)

[Vimarsh]

Thanks Sunny!

Both of your expressions do the job! Thanks so much!