Wrong result from Random function on Mac OS 10.9.2 french
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
Should give something like:
But give something like:
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:
randomNumber = Random;
If ( randomNumber < 1 ; randomNumber ; "," & randomNumber )