Calculated column 'zero' value not being recognized?

[kmacd8]

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.

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

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

[kmacd8]

This worked! Thanks to you, and all that attempted to help!

[Ashish_Mathur]

You are welcome.

[Anonymous]

Hi ,

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

[kmacd8]

sorry - I understand now. Yes - when I input 0.00 as the filtered value - it still has the same result. 

[elJukes]

What happens if you wrap your calculation in a ROUND and set it to two decimal places, then try filtering on 0.00?

[kmacd8]

Tried this. Same issue... In fact - when I try to change the filtered value to '0.00' - it just defaults back to '0'. 

[elJukes]

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.

[kmacd8]

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

[elJukes]

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.

[kmacd8]

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