A have a report that looks like this:
Extended Price
$857.14
$1,357.14
Total Price = $2,214.29 (as you can see it is off .01)
I know that it is some kind of rounding issue, but I have checked everything. Everything is setup to have 2 decimal places. The .14 totals at the top are actually .143. I see what it is doing. It is adding .143 plus .143 to equal .286, then it rounds it to .29 for my total. Does anyone know how to fix this problem. Please help!
AJ
Extended Price
$857.14
$1,357.14
Total Price = $2,214.29 (as you can see it is off .01)
I know that it is some kind of rounding issue, but I have checked everything. Everything is setup to have 2 decimal places. The .14 totals at the top are actually .143. I see what it is doing. It is adding .143 plus .143 to equal .286, then it rounds it to .29 for my total. Does anyone know how to fix this problem. Please help!
AJ
