12 Replies Latest reply on May 26, 2016 11:04 PM by Aman Agrawal

    How to remove decimal values from calculated fields

    Aman Agrawal

      Hi ,

       

      I have created a calculated field. Given below calculated field:-

       

      if [KPI]= 'CS' then AVG([CS])

      ELSE IF  [KPI ]= 'Attempts' then SUM([Attempts])

      end

       

      Now, in CS values is showing like 12.222

       

      I want to show decimal values up to two digits only.

       

      If i am using Default number format --> Custom then it changes all the CS into 12.222 and Attempts like - 13.00

       

      I want CS into 12.22 format(up to two digits)

      and Attempts into 13 format.(Not required in digits)

       

      Using some formula in calculated field..

       

       

      Thanks

      Aman