It would be useful to have a function that generates a random number between 0 and 1, similar to JavaScript's `Math.random()`

.

1 Like

If it is anything urgent, you could try a writing an Evaluator Linear Congruential Generator.

To get random numbers between 0 and 1, divide the pseudo-random output by ( modulus - 1 ).

https://en.wikipedia.org/wiki/Linear_congruential_generator

Edit:

I played with this a little to see if I could generate an Evaluator column of random numbers.

For the modulus I used 2^16 + 1 which is a known Fermat Prime, 2^(2^4) + 1.

The Wikipedia article referenced above has an entry for this with multiplier a = 75 and increment

c = 74 .

The general algorithm is

Here's what I got to work for a Random Number Evaluator Column.

The numbers are not between 0 and 1 yet in this code.

```
m=Pow(2,16) + 1;
a=75;
c=74;
if ( $glob:seed)
{
x=$glob:seed;
}
else
{
$glob:seed=1;
x=1;
}
x=(a*x + c)Mod m;
$glob:seed=x;
return x;
```

Maybe not, the range of numbers generated seems too narrow.