5 Replies Latest reply on Sep 23, 2014 3:44 PM by Matthew Kopetsky

    Concatenate Integer + String

    thierryjakircevic

      Hi,

       

      I have a calculcated field that looks like this:

       

      CASE [Parameter]

      WHEN "String A" THEN Sum([Measure A])

      WHEN "String B" THEN Sum([Measure B])*100

      END

       

      Measure A is an integer but Measure B is a percentage. I want to display the "%" and tried to change the formula as:

      WHEN "String B" THEN Sum([Measure B])*100+"%"

      It does not work.

       

      Is there a workaround?

       

      Thank you!

       

      Thierry