Help

Revenue Formula Rounding Randomly

Topic Labels: Formulas
273 4
cancel
Showing results for 
Search instead for 
Did you mean: 
sibbotso
4 - Data Explorer
4 - Data Explorer

sibbotso_0-1732559442557.png

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.

sibbotso_0-1732562854558.png

 

 

4 Replies 4
Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

@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?

sibbotso
4 - Data Explorer
4 - Data Explorer

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

Ron_Daniel
8 - Airtable Astronomer
8 - Airtable Astronomer

LOL! Yeah, I can see how that would happen. At least you know you got the Airtable part right! 👍

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.