@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?
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
LOL! Yeah, I can see how that would happen. At least you know you got the Airtable part right! 👍
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
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.