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

Summary

Wrong result from Random function on Mac OS 10.9.2 french

Product

FileMaker Pro

Version

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:

,1909294608049094677

Actual result

But give something like:

1909294608049094677

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.

Workaround

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

Let (
       randomNumber = Random;

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

Capture_d%E2%80%99%C3%A9cran_2014-03-08_%C3%A0_12.10.44.png

Outcomes