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)

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

      • elJukes's avatar
        elJukes
        Helper I
        7 years ago

        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.