AnsweredAssumed Answered

Wrong result from Random function on Mac OS 10.9.2 french

Question asked by MaximePaquette on Mar 8, 2014
Latest reply on Mar 13, 2014 by MaximePaquette


Wrong result from Random function on Mac OS 10.9.2 french


FileMaker Pro


Tested on: FileMaker Pro Advanced 10.0.3, FileMaker Pro 11.0.4, FileMaker Pro Advanced 11.0.4, FileMaker Pro 12.0.5, FileMaker Pro Advanced 12.0.5

Operating system version

Mac OS 10.9.2

Description of the issue

Result from the Random function should return a number between 0 and 1, but on some computer it return a number greater than 1, it does not put a comma in front of the number.

If I change the OS language for english, it work fine, if I go back to french i got the wrong result.

See screen shot where I tested on different computer, in red are when the result is wrong.

Steps to reproduce the problem

Set a field to get the result of the Random function

Expected result

Should give something like:


Actual result

But give something like:


Configuration information

I found two computer that have this particular behavior, both are Mac OS 10.9.2 and in french. 

All version of FileMaker on the computer are affected.

Not all Mac OS 10.9.2 in french have the problem.


I have to create a new calculation instead of the Random function, something like:

Let (
       randomNumber = Random;

       If ( randomNumber < 1 ; randomNumber ; "," & randomNumber )