### Title

Rounding Bug?

### Post

This actually should round to 13 right?

Round ( 12,9948000000000002 ; 2 )

But the result is 12,99.

Rounding Bug?

This actually should round to 13 right?

Round ( 12,9948000000000002 ; 2 )

But the result is 12,99.

This is a basic math question. If you compare the typical rounding taught in a grade school math text book to how the Round function works, they are completely consistent.

Rounding 12,9948 to two decimals means that you examine the 3rd digit after the decimal. That value is 4. Values of 4 or smaller are simply discarded. Values of 5 or larger result in adding 1 to the digit to the immediate left. The value of the 4th digit, 8 in this case has no effect on how the number is rounded.

Thus, the correct value returned is 12,99---exactly the value returned by this FileMaker function when you specify a parameter of 2 for 2 decimal places.

If you want to only see whole numbers i would think to try Round(field;0), or do you need to see the number to 2 places?