Forum Discussion
Filtering out Zero (0) value from table not working
hi community,
I am trying to filter out "0.00" 's from my report but for some reason they wont get excluded.
I tried to copy one of the 0.00 values from the repor to notepad and it showed as -9.313225746154785e-10 even though it shows as "0.00" in the report.
However, even with the filters applied 0's still come up
Above you will also see i tried to conditionally format 0 to be green flagged. But some are green and others red even though the logic for red flag is anything < 0 or > 5
Is there anyway to filter out these 0 values ?
It is a measure. I have managed to resolve thanks.
Used i wrapped my meausre in ROUNDUP and that fixed it.
Thanks.
2 Replies
What is the data type set as for your field with the 0.00 showing? Is it a measure? Is it an actual field?
It is a measure. I have managed to resolve thanks.
Used i wrapped my meausre in ROUNDUP and that fixed it.
Thanks.
