3 Replies Latest reply on Dec 3, 2018 9:00 AM by LaShawnta Barker

    Concatenate a measure with a % sign in 10.x

    LaShawnta Barker

      I would like to concatenate the % sign to the calculated field [%Response (copy)].

      I know this question has been asked but never successfully answered. I have this calculated field and I receive an error "Expected type string, found float. Result types from "IF" expressions must match." Is there a way around this?

       

      IF [Parameters].[metric selector 2]= "%Response" THEN  STR(ROUND([% Response (copy)]*100,1))+ "%"

      ELSEIF  [Parameters].[metric selector 2]= "Overall Score" THEN ROUND([Overall Score],1)

      END