 # 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 18:19 (external edit)   