Skip to main content

I know this is simple but I’m struggling for some reason. {Average Weight}/2000 * {Base Rate} + {Surcharge Calc} It adds the ‘Surcharge Calc’ which is a percentage just as a number.


What I’m trying to accomplish: Average Weight = 10000, Base Rate = 15, Surchage Calc = 20%

10000/2000 X 15 + 20% = 90

I’m getting 75.20


Thanks

Yeah…percentages are sort of just treated as decimals on Airtable, so to achieve what you’re looking for you’d probably need to do something like the following I’m afraid


({Average Weight}/2000 * {Base Rate}) * (1 + {Surcharge Calc})

Yeah…percentages are sort of just treated as decimals on Airtable, so to achieve what you’re looking for you’d probably need to do something like the following I’m afraid


({Average Weight}/2000 * {Base Rate}) * (1 + {Surcharge Calc})


Thank you that fixed it!

Reply


Terms & Conditions