5 Replies Latest reply: Jan 15, 2013 11:01 AM by Francesco Puppini RSS

    Cannot get a 0 just Null values

    Helen Pippard

      Hello

       

      Could someone kindly look at the following expression I have written in a Pivot table

       

      I would like to show 0 values if the sum of inline_Monthly_Data_A is Null

       

       

      If

      (IsNull(Sum(Inline_Monthly_Data_A)),0,sum(Inline_Monthly_Data_A)))

       

       

      With the above I am getting - values

       

      Can anyone help?

       

      Kind Regards

      Helen