Use set analysis to exclude NULL results in a KPI measure

Darren1 — Tue, 28 Dec 2021 18:40:30 GMT

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!

Re: Use set analysis to exclude NULL results in a KPI measure

brunobertels — Wed, 29 Dec 2021 08:43:44 GMT

hi may be one of this

Sum({<[WIP.fips] = {'*'}-{''}>} [goal])

Sum({<[WIP.fips] = {"=not isnull([WIP.fips] )"}>} [goal])

topic Re: Use set analysis to exclude NULL results in a KPI measure in App Development

Use set analysis to exclude NULL results in a KPI measure

Re: Use set analysis to exclude NULL results in a KPI measure