Convert percent to number

[Phil_Waite]

I have a percentage (for example 3.9% ABV of beer) that is used to calculate a price with the formula below

Percentage ABV x 10 + 20

So 3.9+10+20 = 59

How do I convert the percent to a decimal. I have tried changing the column type to decimal and used NUMBER() but nothing changes the percent.

Thanks

Phil

[Aurelien]

Hi @Phil_Waite 

Are all of your numbers involved set with type Decimal ?

Percentage is just a decimal displaying, with an unit "%".

If you have AVB set as Percentage, and [Decimal1] and [Decimal2], then your expression would become:

[AVB]*[Decimal1]+[Decimal2]

Then, you may want to set your output Decimal options with no decimal digits.