This content has been marked as final.
Show 4 replies

1. Re: How to Add text or symbols to formula?
Chris McClellan Feb 17, 2017 12:37 AM (in response to anjani divi)3 of 3 people found this helpfulThe 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.

2. Re: How to Add text or symbols to formula?
Clifton Pereira Feb 17, 2017 1:19 AM (in response to anjani divi)4 of 4 people found this helpfulHi Anjani,
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)] + " %"
Thanks
Clifton

3. Re: How to Add text or symbols to formula?
Sankarmagesh Rajan Feb 17, 2017 1:22 AM (in response to anjani divi)3 of 3 people found this helpful 
4. Re: How to Add text or symbols to formula?
anjani divi Feb 17, 2017 2:03 AM (in response to Clifton Pereira)Thank you