Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Reformat Field to Percent

hi is it possible to reformat a field to be a percent, even if the value is alreday an integer number? for example, if the data under 'percent' is 98, 97, 22, etc, and these values are actually ...

Need Help

v-jiascu-msft
8 years ago
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