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])



      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..