GROW

Syntax

GROW (Dimension, Start Value, Growth Rate)

Description

The GROW function returns a number representing the specified Growth Rate per Member from Start Value. This is a straight line growth function.

Example

Suppose that an analytic model contains single value data cubes called SALES_START and ANNUAL_GROWTH. You can project the monthly sales with the following formula:

GROW(MONTHS, SALES_START, ANNUAL_GROWTH / 12)

Note that you must divide ANNUAL_GROWTH by 12, because the GROW function expects a growth rate per member, and the members in this case are months.

Note:

For the GROW function to return meaningful results, the Start Value and Growth Rate arguments should not use the dimension indicated by the dimension argument. For example, if you are calculating monthly values, the Start Value and Growth Rate arguments should not use the MONTHS dimension.