Random Number (Expression Function)

Purpose

The Random Number function (RANDOM_NUMBER) generates a random number between the minimum and maximum value.

Parameters

The Random String function has two required parameter:

Minimum Value

Allowed Inputs: field value or a number

Either use the use the Query Builder to choose a field that contains a number to use or type a value to enter a number.

Maximum Value

Allowed Inputs: field value or a number

Either use the use the Query Builder to choose a field that contains a number or use type a value to enter a number.

Output

The output of the Random Number function returns a random number. The chances of two iterations of the Random Number function generating the same number more than once is based on the size of the range allowed. A minimum value of 0 and a maximum value of 1 would produce a 1 in 2 chance of getting the same value because there are only 2 possible values.

String Length

If you want a specific number of digits set the minimum and maximum values accordingly. For example if a length of 6 digits is required enter 100000 as min and 999999 as max and the function will always get a 6 digit number.

Example

RANDOM_NUMBER(1,100) would result in a random number. Possibly “33”.

expression function - random number.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2020