dPaid = 143.22 and b.ppTotal = 47.74. If I simply divide the remainder is 0. But the result of this is in JAVA (and also using MOD in excel) is 47.74.
(Math.abs(dPaid % b.ppTotal))
Asked
Active
Viewed 53 times
0
-
4See also: [Is floating point math broken?](https://stackoverflow.com/q/588004/3282436) – 0x5453 Mar 16 '23 at 13:00
-
Yea ... this is a binary floating point rounding error problem. – Stephen C Mar 16 '23 at 13:01
-
2And ... also ... an illustration of why you shouldn't use floating point for accounting. – Stephen C Mar 16 '23 at 13:03
-
What should you use for accounting instead? – cjingeorgia Mar 16 '23 at 13:11
-
1Actually, the result in Java is 47.739999999999995 which demonstrates the rounding error that @StephenC was talking about. – WJS Mar 16 '23 at 13:11
-
1@cjingeorgia BigDecimal or convert dollars to cents. I would prefer BigDecimal. – WJS Mar 16 '23 at 13:11