1 Reply Latest reply on Nov 13, 2018 3:19 PM by Hari Ankem

    Calculation on Percentage Values

    NAYANA MADHEKAR

      Hi I have a question on a calculation:

       

      I have a column with percentage values

       

      Column A:

      100%

       

      116%

       

      50%

       

      80%

       

      102%

       

       

      I need a calculated field that can give me values to 8%.

       

      ie; If Column A = 100% then 8%

      If Column A = 50% then 4%

       

      and if more than 100% then keep it to 8%.

      Can we do this?