+5I 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
Best answer by TheTimeSavingCo
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})
+31Yeah…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})
+5Yeah…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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.