How do we suppress rows with zero amounts on fields of measure? I can't filter out zeroes because the filter type is "range." I tried using a CaseIf function and the <> operator with no success. Please advise if this is possible.
Hi @Molly P If the filter type is range then give the range between 1 to <some big number> . So, that the rows with value 0 will get excluded.
This won't work as we need to see negative values as well. The only value we want to exclude is 0. Thanks, Molly
We have an exact same requirement and need to figure out a way simple enough for a business user to exclude records with 0 amounts.
It's a while I have looked at it, but can you see if it there is an option to create a calculated field. If yes, then create it by checking value is 0 or not. Now you can use this field as a filter. Hope it helps!
