Python calculation issue for certain numbers

Question

I'm using Odoo 10 and I have met some rounding issue with calculation using Python. For example: My formula is:

a = 224.689511
b = 195.382186
c = 1000

return round((a - b) * c, 2)

The return value is 29307.32 But the correct value is 29307.33

Value before rounding is 29307.324999999997 but it should be 29307.325

Is there any solution for this kind of case?

Refer this [Floating point issue](https://stackoverflow.com/questions/10403434/floating-point-in-python-gives-a-wrong-answer) — Sociopath, Sep 27 '19 at 08:17

score 0 · Answer 1 · answered Sep 27 '19 at 09:00

0

29307.325 rounds up to 29307.33, since you want only 2 decimal places

answered Sep 27 '19 at 09:00

Ishan Joshi

Yes. That's what I want. But if you run my code above, it actually return 29307.32. Because the actual value before rounding is 29307.324999999997 – Suparjito Sep 27 '19 at 09:04

1 Answers1