Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 02, 2024 12:04 PM
I am building out a process to make billing time and invoicing easier. Unfortunately the formula I'm using either results in $1 or a total that's completely incorrect.
How in the world is it calculating $216?
Should be 7 * $33.33=$233.31
Feb 02, 2024 12:39 PM
33.33 * 6.5 equals 216.65, so I suspect you have a rounding issue where 6.5 is displayed as 7.
Feb 03, 2024 07:00 AM - edited Feb 03, 2024 07:04 AM
Hmmm. I just created three fields to duplicate your table. I put actual numbers in as I don't have assess to data to do a rollup. So one field with a 7 in it and another with 33.33 in it. When I calculate it in a third formula field I get $233.31. I set the formatting to currency and 2 decimal points. I think BillH has it right. It must be a rounding error in the rollup field. Check the setting on the formatting tab in the rollup field to make sure you are sending 7 to the rollup field.. Hope this helps. Best, Scott
Feb 05, 2024 10:25 AM
@billg You were right! It was a rounding issue. Thanks so much for your help.