I am using the following measure to dinamically generate a string
Case development =
VAR LY = [NrCases(Var LY SM CD)]
VAR LM = [NrCases(Var MTD LM CD)]
VAR OvUndLM = IF(LM >0 , "over", "under")
VAR OvUndLY = IF(LY >0 , "over", "under")
"The Nr of cases is currently " & LM & " " & OvUndLM & " last month and " & LY & " " & OvUndLY & " the same month last year"
My problem is that the measures [NrCases(Var LY SM CD)] and [NrCases(Var MTD LM CD)] are showing up in the result as decimal numbers, even though I have them formatted as percentages.
Can I use FORMAT on the variables to force the format as percentage?