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.
