Forum Discussion
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, ...
Hi,
Try this calculated column formula
=IF(your calculated column formula=0,BLANK(),your calculated column formula)
Yes - the screenshot below shows the data type and format as decimal number. Also - I have double checked to be sure that each of the referenced columns from the fomula are also showing as a 'number' within the data type.
(Thanks for trying to help me out here).
Not a problem - I'm at a loss! Perhaps it may work with the filter condition set to greater than 0? Otherwise it may be a bug with the filter pane. Maybe worth trying applying the filter using a slicer or the old visual filter panel.
Sorry I couldn't be of more help.