Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add % symbol to values

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?

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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!