Forum Discussion

kmacd8's avatar
kmacd8
Frequent Visitor
7 years ago
Solved

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, ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Try this calculated column formula

    =IF(your calculated column formula=0,BLANK(),your calculated column formula)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi ,

 

Are the results the same when 0.00 value is inputed in the "is not" field

kmacd8's avatar
kmacd8
Frequent Visitor
7 years ago

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...