140.76 - 132.75 =?

I’ve simple compute number field “difGeneration” with simple formula B01 - B02, B01 = 140.76

B02 = 132.75

(B01, B02 also Number field)

Result from this formula should be 8.01 but it display 8.00999999999999 !!!

I’ve tried in many Notes Application, result are the same.

Nakorn Ph.

Subject: Welcome to the world of computing.

Computers do not work in base 10 then work in binary, everything is stored as 1’s and 0’s

Most of the time, people never see a problem, but sometimes it’s possible that an exact representation of your number cannot be stored in binary format, which can lead to numbers like 140.76 being stored as 140.75999999999 for example.

Take a look at @round in help and use that in your formulas. Also search google for rounding errors so you can learn more as to why this happens.