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



      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]




      Screen Shot 2017-05-18 at 12.41.16.png

      Thanks in advance,