Forum Discussion

Anonymous's avatar
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's avatar
    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

mow700's avatar
mow700
Resolver I
8 years ago

I would create a new column and probably use the FORMAT() function in conjunction with the calculation.

New Column = FORMAT([Original Column]/100,"Percent")

You could always transform this column in the original query as well.  If you never need this data as an int that's likely the best way to handle this.