topic Set Analysis with Multiple GetFieldSelection in App Development

Set Analysis with Multiple GetFieldSelection

Vimarsh — Sat, 16 Nov 2024 04:11:45 GMT

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!

Re: Set Analysis with Multiple GetFieldSelection

sunny_talwar — Fri, 01 Nov 2019 13:31:56 GMT

Try this instead

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

Re: Set Analysis with Multiple GetFieldSelection

sunny_talwar — Fri, 01 Nov 2019 13:32:31 GMT

or this

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

Re: Set Analysis with Multiple GetFieldSelection

Vimarsh — Fri, 01 Nov 2019 13:39:16 GMT

Thanks Sunny!

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