Change data type percentage multiplies times 100

[Anonymous]

Hi,

Quick and probably easy question on how to solve the following:

My percentage is e.g. 0,01 in my data table, now when I change the data type it changes to 1%.

Can someone help me on how to keep the percentage at 0,01?

Kind regards,

Ilka

[CrisYan]

Leaving the column data type in "Decimal Number" (if you want to keep that format)

[MarcelBeug · Accepted solution]

Well, 0.01 = 1%, so there is no multiplication.

You can divide the values by 100.

[Anonymous]

Had to perform the divided by 100, although I still think it's strange, probably has something to do with my , and . settings