9 Replies Latest reply: Dec 28, 2017 4:37 AM by Sunny Talwar RSS

    Replace to zero

    sony sing

      hi all,

      I have a pivot table  with the measure result is showing as null symbol

       

      but I want to show as zeros in place of nulls

       

      I tried different methods  but no luck

       

      Dim:group

      column:Date

      Mesaure: groupvalue

       

      tried

       

      if(groupvalue='-' or isNull(groupvalue),0, groupvalue)

       

       

       

      Thanks

      sony