1 Reply Latest reply: Apr 11, 2016 1:48 PM by Agnivesh Kumar RSS

    How to apply "Cr" "Lacs" logic to null values.

    Sandeep Joglekar

      Hi,

       

      The below logic for showing values in Cr, Lacs and Abs is not getting applied for Null values. Because of which when we select "Cr" the pie chart shows the null values as the highest share and rest value as minuscule.

       

      Num(

       

      sum([Order Value])

      /

      if(Currency='Cr',10000000,

      if(Currency='L',100000,

      1))

       

       

      ,'#,##0.00'&if(Currency='Cr',' Cr',

      if(Currency='L',' L'))

      )

       

      Regards,

       

      Sandeep Joglekar