RAND
The RAND function returns a random decimal number between 0 and 1. A new random value is generated each time the function is evaluated or the report is refreshed. This function is commonly used in simulations, sample data generation, testing scenarios, and calculations that require random values
Syntax
RAND()Return value
Returns a random decimal number greater than or equal to 0 and less than 1.
Example
RAND()In the example below, the Rand measure is created using the RAND function, which generates a random decimal number between 0 and 1 each time the report is evaluated or refreshed.
Excel equivalent
Last updated
Was this helpful?