How to show trailing “%” symbol?

Question

In SO Line's discount pct column, i'd like to show trailing "%" in it.

I tried to set the display format to "P" but it was a disaster :)

Because the actual value is the percentage rate in the database, it unnecessarily multiply it with 100.

Thanks for the answers.

Answer 1

You should set the DisplayFormat to 0.00'%'

and as a result you will get the following:

If you don't want to show the decimal part use 0'%'.

UPDATE

You may use #,##0.00% Display Format.