
Contributor III
2021-12-28
01:40 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
Sum({<[wip_bmp] = {'Cover Crop'}, [WIP.year] = {'2025'}, [type] = {'Agronomic'}, [WIP.county] = {'Allegany'}, [WIP.fips] = {'*'}>} [goal])
In my attached picture I would like to exclude the records with no value in the fips field (red mark).
Thanks!
854 Views
1 Reply


Master
2021-12-29
03:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi may be one of this
Sum({<[WIP.fips] = {'*'}-{''}>} [goal])
Sum({<[WIP.fips] = {"=not isnull([WIP.fips] )"}>} [goal])
790 Views
