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

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

  • elJukes's avatar
    elJukes
    Helper I
    7 years ago

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

    • kmacd8's avatar
      kmacd8
      Frequent Visitor
      7 years ago

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

      • elJukes's avatar
        elJukes
        Helper I
        7 years ago

        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.