Invoicing Formula Not Correct Total

[mnand]

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

  

[BillH]

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

[Scott_Brasted]

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]

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