- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 25, 2024 10:33 AM - edited Nov 25, 2024 11:27 AM
Revenue = Quantity * Price
7496.90 = 150 * 49.98
Why is the number rounding up to 7497.00????
Another Example: $205.80 = 25 * $8.23
The value I get in my Revenue Cell is rounded down to $205.75.
Here is the revenue formula vs. what it should be. The numbers are rounding weirdly.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 25, 2024 11:46 AM
@sibbotso -
In my calculator, 150 * $49.98 does equal $7,497.00. And 25 x $8.23 does equal $205.75.
Why are you expecting to see $7496.90 and $205.80?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 25, 2024 12:53 PM - edited Nov 25, 2024 12:55 PM
Haha you're not wrong...
Here's how I got here: In the interest of making revenue a calculated field moving forward, so that upon a sale, the sales person can simply enter the quantity and price corresponding to the sale. I divided what was a static value of $7496.90 (which is the real amount money received) by the quantity sold to find the per unit price of all the past sales.
$7496.90 / Quantity (150) = 49.98
I then imported all the unit prices into Air table and multiplied them by the quantity.
49.98*150 = $7,497.00
Am I losing my mind? I need the numbers to add up to $7496.90

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 25, 2024 12:56 PM
LOL! Yeah, I can see how that would happen. At least you know you got the Airtable part right! 👍

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 25, 2024 03:40 PM
You're not losing your mind. But you seem to have introduced a rounding error in the Price column by rounding 49.9793333333 to 49.98
Use the value till i'd say, 8th decimal, to get rid of the error.
