
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 26, 2022 06:15 AM
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
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 26, 2022 06:29 AM
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})
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 26, 2022 06:29 AM
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})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 26, 2022 06:40 AM
Thank you that fixed it!
