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
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.
