3 of 3 people found this helpful
The best way would be to format the calculated field to be a percentage. That way Tableau will still treat it like a number but add the % sign at the end.
If you use the current approach, Tableau will think it's a string (aka text) and you won't be able to manipulate it like a number. I'm guessing your error is because you're not using the STR function around the numeric calc.
4 of 4 people found this helpful
Please do this
Put your calculation.Right click on calculated field, then click on Default Properties, click on "Number Format" then click on "Percentage".
Or else try this
str([Calculation)] + " %"