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)

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.

       

       

      • kmacd8's avatar
        kmacd8
        Frequent Visitor
        7 years ago

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