5 Replies Latest reply on Jun 20, 2017 4:57 AM by Akhilesh Singh

    Adding a string to a calculation

    devesh sharma

      Hi All,

       

      I am trying to add a string  "%" in front of the calculation so that the marked labels have % sign in front of them.

       

      My calculation is as follows :

       

      case [Data Type]

      when "% Diff" then      (ZN([Volume (No Dupe) (copy)]) - LOOKUP(ZN([Volume (No Dupe) (copy)]), -1)) / ABS(LOOKUP(ZN([Volume (No Dupe) (copy)]), -1))*100

      when    "Volume" then [Volume (No Dupe)]

      when "Smooth Volume" then WINDOW_AVG([Volume (No Dupe)], -2, 2)

      END

       

      now i want a string % after the calculation performed in

       

      "% Diff" then      (ZN([Volume (No Dupe) (copy)]) - LOOKUP(ZN([Volume (No Dupe) (copy)]), -1)) / ABS(LOOKUP(ZN([Volume (No Dupe) (copy)]), -1))*100. Which means whatever value comes it should include a % sign after it.

       

       

      Thanks