GetSelectedCount not working on individual field

donschmitz — Tue, 25 Sep 2018 15:10:28 GMT

I'm using a variable to create a Title for my graphs based on filter selection the filter is just =[PROVIDERS.PROV_NAME]

It works fine making a filter selection for SURGERY_SECTION & ACADEMIC_SECTIONS but fails to work for PROV_NAME

and I'm stumped as to why?

The basic idea is filtering on these three fields restricts the PROV_ID Key field

Variable vTitle

=IF(GetSelectedCount([PROVIDERS.SURGERY_SECTION]) > 0, GetFieldSelections([PROVIDERS.SURGERY_SECTION])&' Sub-Section',

IF(GetSelectedCount([PROVIDERS.ACADEMIC_SECTION]) > 0, GetFieldSelections([PROVIDERS.ACADEMIC_SECTION])&' Section',

IF(GetSelectedCount([PROVIDERS.PROV_NAME]) > 0, 'Specific Provider', 'Entire Department')))

GetSelectedCount always returns "0" even if multiple are selected.

topic GetSelectedCount not working on individual field in App Development