Forum Discussion
kmacd8
7 years agoFrequent Visitor
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, ...
- 7 years ago
Hi,
Try this calculated column formula
=IF(your calculated column formula=0,BLANK(),your calculated column formula)
Anonymous
7 years agoNot applicable
Hi ,
Are the results the same when 0.00 value is inputed in the "is not" field
kmacd8
7 years agoFrequent Visitor
sorry - I understand now. Yes - when I input 0.00 as the filtered value - it still has the same result.