Forum Discussion
Reformat Field to Percent
Hi Anonymous,
I get the whole idea now. If you don't want to add a new column, you have to divide the values by 100 first.
1. Open Query Editor, apply "Replace values" once. Whatever the values are. We only need this step to generate some codes for us.
2. Open "Advanced Editor". Replace the blue part with this:
each [Column1], each [Column1] / 100
3. Change the Format to "Percentage".
Best Regards!
Dale
Anonymous,
Hi Dave,
I'm a little confused. Why not change the format directly?
Best Regards!
Dale
- Hi Dale,
When you say original query do you mean the query editor? - v-jiascu-msft
Don't think you fully understand the question, changing to the percent format is simple but unfortunately the raw data is already showing as a percent, this was explained in the original post in better detail. If I just change the column to format percent i get 9800%, 5000%, even when I need it to read 98% and 50%Hi Anonymous,
I get the whole idea now. If you don't want to add a new column, you have to divide the values by 100 first.
1. Open Query Editor, apply "Replace values" once. Whatever the values are. We only need this step to generate some codes for us.
2. Open "Advanced Editor". Replace the blue part with this:
each [Column1], each [Column1] / 100
3. Change the Format to "Percentage".
Best Regards!
Dale
Thats brilliant Dale, thank you