Showing % with additional 00 in a column

[Anonymous]

Hi,

I have a column abc, data type is Whole Number where one of the value is 20. Now i want to show it as 20 % but when i  am using  Modeling tab --> Format - Percentage then it is showing me 2000 %  and if i use Standard deviation then value is showing 0.00.

.

Could you plz help me with this.

[Anonymous]

Hi SubhamK,

Whole number divided by 100 and then apply percentage format in your modelling tab. This would helps.

Normally Percentage format would multiply your number with 100.

Ex. Whole Number is 20 

20/100 = 0.2 

0.2 * 100 = 20%

Regards,

Pradeep

[yelsherif · Accepted solution]

The value cannot be changed from whole number into % as a percentage means that the value is divided by 100.

You can do one of 3 changes:

1. create a new column to divide the values by 100, e.g. column = [abc] / 100

2. concatenate % sign to the value, but the result will be text, e.g. column = [abc] & "%"

3. change the original calculation where the value came from, e.g. abc = <calculation> / 100