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
Invoicing Formula Not Correct Total
+2
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
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.