Help

Invoicing Formula Not Correct Total

Topic Labels: Formulas
917 3
cancel
Showing results for 
Search instead for 
Did you mean: 
mnand
4 - Data Explorer
4 - Data Explorer

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

Screenshot 2024-02-02 at 11.53.08 AM.png

Screenshot 2024-02-02 at 11.53.18 AM.png

  

3 Replies 3

33.33 * 6.5 equals 216.65, so I suspect you have a rounding issue where 6.5 is displayed as 7.

Scott_Brasted
7 - App Architect
7 - App Architect

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

mnand
4 - Data Explorer
4 - Data Explorer

@billg You were right! It was a rounding issue. Thanks so much for your help.