Add % symbol to values

[Anonymous]

I have a column of values such as 0.00, 20.60, 100, 53.48. I want to change the formatting of the values so that they are 0.00%, 20.60%, 100%, 53.48%.

However, when I try to convert to a percentage the values are always converted into: 0%, 2060%, 10000%, 5348%. I have tried to convert to a percentage format within the field properties, the modeling tab, and in the query editor with no luck. It will always convert into a percentage in the thousands.

How can I add the % to a column of values that are already a percentage?

[Anonymous · Accepted solution]

Hi

It may be that the simpilest answer to this, is to create a custom column, dividing the column you with to convert to a percentage by 100 and then formatting that as a percentage.

You can then hide the original column in your model so that it isnt used by accident.

Thanks

[Anonymous]

The original column with the percentage values was filtered so that it would show the average percentage. Unfortunately, I was not able to create a new calculated column from the original column (because it used the average filter). I had to recreate the average filter, and then use the steps you mentioned.

Thanks!