Help

% fields treated as integers in calclualtions

Topic Labels: Formulas
2022 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Larry_Price
6 - Interface Innovator
6 - Interface Innovator

This seems silly to me, but it appears that any percentage type field used in a calculated field is treated as a number instead of a percentage.
For example:
A percentage field set at 20%
A currency Field set at $500
multiplied together = $10,000

Change the 20% to 0.20% and then it equals $100.

Maybe this is intentional, but I cant’ figure out why.

2 Replies 2
Katherine_Duh
Airtable Alumni (Retired)

The best workaround for this right now is to include a constant in the formula (i.e., multiply the result by .01). We recognize that this is suboptimal behavior and we do plan on addressing it in the future.

3fd2609c6fd40a4f624dac9e283a757425b44bdb.png

Tanks for the quick response.