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)
Interesting. In the report view, click on the modelling header and then click on your calculated column. In the middle of the modelling tool bar, does it have number listed as the data type?
Might be an error or something non-numeric is being output by the formula for your column.
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).