# WRONG MATH : Multiplying by 100 change the result of decimal numbers, loss of precision

Question asked by Vincent_L on May 21, 2014
Latest reply on Dec 16, 2016 by jbante

### Summary

WRONG MATH : Multiplying by 100 change the result of decimal numbers, loss of precision

FileMaker Pro

13.0v3 / 11.0v4

### Operating system version

Mac OS X 10.9.3 / Window 7

### Description of the issue

Here's a math operation :

1-1,975/6,5833333333333333 = ,7

Now let's multiply that result by 100, so we should get 70 :

(1-1,975/6,5833333333333333) *100 = 69,9999999999999998

So we went from a round result to one with lots of decimals.

So now let's do a Floor on this result :

Floor( (1-1,975/6,5833333333333333) *100) = 69

Doing the same operation in Mac OS X Alfred calculator gives correct result. Perhaps the *100 is correct but the first result is false

Test ran on Mac OS X.9.3, FMPA 13.0v3

*** IMPORTANT UPDATE ***
THIS OCCURS IF DECIMAL SEPARATOR IS COMMA

1-1.975/6.5833333333333333)*10 is ok (of course you've to set your OS with . as decimal separator).

So the bug a appears on Languages that use COMMA as decimal separators

### Steps to reproduce the problem

Do the above math operation

70

### Actual result

69,9999999999999998

### Configuration information

FMPA 13.0v3 / 11.0v4 (didn't try 12)
Mac OS X 10.9.3 / Windows Seven
OS decial separator is a COMMA not dot

None