How to randomize between two numbers?

HCL Domino Domino Forum
1

I have two numbers fields. In those fields I put to numbers. I’d like to have result , five randomize numbers in five fields.

for example:

in field 1 we put= 1

in field 2 we put= 250

result should get 5 rendomized numbers : 45, 100, 2, 203, 176

result couldn’t be <1 and > 250!

2

Subject: How to randomize between two numbers?

thanks

3

Subject: How to randomize between two numbers?

From the Domino Designer Help:

To generate a random number between any two numbers x and y, use the formula

( y - x )*@Random + x

4

Subject: be careful - this may result in X or Y!

@Random CAN return 0 or 1 - not likely but then you would get numbers your original post excluded

In addition this will be fractional numbers

you may need and @Integer or @Round.

and there is also a small change that the same number will be generated twice.

(More like with @Integer and a small range of course)

if you need five unique numbers then you have more work to do.