Use set analysis to exclude NULL results in a KPI measure
I would like to use set analysis to exclude NULL results in a KPI measure. However when I use the scripts below it does not exclude the NULL results and displays the full "goal" total. The "WIP.fips" is a string field.
Sample script:
Sum({<[WIP.fips] = {'*'}>} [goal])
This is the full set analysis I am trying to create: