4 Replies Latest reply on May 18, 2017 3:42 AM by Simon Runc

    Convert data into percent format without string data type

    Karolina Skvortsova

      Hi,

       

      I have my data value as 0.20.  I would like to convert into percent format as 20%.  Does anyone know how to convert it in calculated field and not to make it into a string data type as I need to calculate totals further.

       

      I use the following formula now with parameter:

       

      IF [Choose value]='Absolute' THEN [Number of Tasks]

      ELSEIF [Choose value]='Percent' THEN [% of Total]

      END

       

       

      Screen Shot 2017-05-18 at 12.41.16.png

      Thanks in advance,

      Karolina