I'm using the Filemaker 11 Pro & FileMaker supplied Invoice example. I have line items that are as follows:
Qty 4992 price .01 extended price 49.92
Qty 4992 price .002 extended price 9.98 (actually 9.984 in Excel)
Qty 5312 price .002 extended price 10.62 (actually 10.624 in Excel)
I get a total of 70.53 It should be 70.52. (actually 70.528 in Excel)
It shouldn't be rounding up on 3 decimal places.
What do I need to change?