Forum Discussion
Calculated column 'zero' value not being recognized?
Hi community,
I have what I assume is a simple question regarding a cell in my table not being recognized as a zero.
I have a calculated column, formatted to be a fixed decimal number data-type, and a decimal number. The calculated column has several distinct values, one of which is showing as 0.00 (which is calculated correctly). However, when I apply a visual filter to exlude items that are equal to zero - I am still getting the "0.00" showing up in my report?
Any help is much appreciated.Visualization showing zeros despite my filter?Calculated column values from table-viewCalculated column.
Hi,
Try this calculated column formula
=IF(your calculated column formula=0,BLANK(),your calculated column formula)
11 Replies
You mean as the 'is' field? The original filter is setup as 'is not' -
When I change the filter to be 'is' - yes, I lose the zero's from the visualization... I'm sorry if I am misunderstanding your follow up...
sorry - I understand now. Yes - when I input 0.00 as the filtered value - it still has the same result.
What happens if you wrap your calculation in a ROUND and set it to two decimal places, then try filtering on 0.00?
Hi,
Try this calculated column formula
=IF(your calculated column formula=0,BLANK(),your calculated column formula)
This worked! Thanks to you, and all that attempted to help!
You are welcome.
