2 Replies Latest reply: Jun 5, 2013 2:27 AM by Robert Waterval RSS

    Showing zero as null

    Robert Waterval

      Hi guys,

       

      I want to make a grafic logritmic but these zero values are have to be converted to null.

      Whats the correct if statement for this expression?

       

      Orginal statement:

       

      sum ({$<Rep_Plant={'V','W'}, Rep_Year={">=$(#=year(today())-1)"}, Rep_YrMnth -= {$(=Date(today(),'YYYYMM') )

       

       

       

      Month Turnover

      201301 11619989

      201302 11629800

      201303 11406161

      201304 11410011

      201305 11193259

      201306 0              

      201307 0               

      201308 0          

      201309 0          

      201310 0          

      201311 0     

      201312 0          

       

      Best regards,

      Robert