RAND

Syntax

RAND ()

Description

The RAND function returns a random decimal number greater than or equal to zero and less than one.

The RAND function uses an industrial strength random number generator with an extremely long period. Thus, it is suitable for use in statistical simulation.

The Analytic Calculation Engine RAND function does not cause a cube to be calculated during every recalculation, unlike in Microsoft Excel. Formulas that use RAND typically refer to some other data in the analytic model, and the analytic calculation engine recalculates the cube only when the other data changes. If you use the RAND function to populate a cube with data for demos or testing and you do not refer to other cubes the data in the cube does not change unless you edit the formula or calculate the data cube.

Returns

A random decimal number greater than or equal to zero and less than one.

Example

RAND() returns 0.938119738.