Forum Discussion
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 ...
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?
When you say original query do you mean the query editor?