AnsweredAssumed Answered

Calculation bug

Question asked by R.Schmidt on Jun 8, 2012
Latest reply on Jun 8, 2012 by R.Schmidt


Calculation bug


FileMaker Pro



Operating system version

MacOS 10.6.8

Description of the issue

I have a calculation field in which I show the VAT content of a number in a data entry field, i.e. a 1 / 6 fraction of the number from the data entry field.  So £6.00 (i.e. £5 + 20% VAT) entered in the data entry field should show £1.00 in the calculation field. Instead, the result of the calculation is £100000000000, i.e. the decimal point is missing / incorrectly positioned.

Steps to reproduce the problem

This appears to be a calculation bug associated with the use of a fraction (i.e. 1 / 6) to perform the calculation. If £5.99 or £6.01 is entered in the data entry field, the calculation is correctly performed. The calculation is also correct for other whole numbers EXCEPT FOR multiples of 6.  So 24 in the data entry field produces £400000000000 in the calculation whereas 24.00000001 in the data entry field produces £4.000000001666666700000000000, which shows as £4.00 to 2 decimal places.


The workaround (for me, because I am calculating a 1 / 6 fraction) to is simply to enter a number that is not 6 or a multiple of 6.  So I enter, for example, 6.0000001 instead of 6