Post

2 followers Follow
0
Avatar

How to add the '%' symbol in chart column

Hi,

Our customer would like the to see a % sign next to a percentage value in the column of a report.  Not sure how to mix a calculated percentage with a text % symbol?  Anyone know how to do that?

Karen Hopson Answered

Please sign in to leave a comment.

3 comments

0
Avatar

Hello Karen,

This can be done by using a formula column:

I hope this helps.

Roland

Roland Pumputis 0 votes
Comment actions Permalink
0
Avatar

I tried this but the tool wouldn't accept it because I was mixing a number with text.  I also tried to convert it to text and because it is a percent field it wouldn't convert it.  It wanted it to be a number in order to convert to text?  Still stuck....

Karen Hopson 0 votes
Comment actions Permalink
0
Avatar

Hi Karen,

Please make sure you select Text as the field type and let me know if that works:

Thank you!

Roland

Roland Pumputis 0 votes
Comment actions Permalink