@GROWTH

The @GROWTH() function calculates a series of values that represent a linear growth of the first nonzero value encountered in principalMbr across the specified rangeList. Growth is calculated by multiplying the growth rate in rateMbrConst by the original principalMbr. This value is then added to the previous time period's result, yielding the new value.

Syntax

@GROWTH(principalMbr, rateMbrConst [, rangeList])

principalMbr Single member specification that represents the initial value of the value to grow. The first nonzero value encountered is the initial value. Other principalMbr values after the first are ignored.

rateMbrConst Single member specification, variable name, or numeric expression providing a constant value that represents the decimal growth rate to be applied (for example, 10% = .1).

rangeList Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.

Notes

Financial functions never return a value; rather, they calculate a series of values internally based on the range specified.

Example

The following example calculates the growth of Principal Amount, using the rate found in Growth Rate for each fiscal year. The results are placed in Growth Amount.

"Growth Amount"=@GROWTH("Principal Amount","Growth Rate",FY1991:FY1996);

This example produces the following report:

                   FY1991 FY1992 FY1993 FY1994 FY1995 FY1996
                   ====== ====== ====== ====== ====== ======
				 
Principal Amount    1,000      0  2,000      0      0      0
Growth Amount       1,050  1,120  1,200  1,280  1,380  1,480
Growth Rate          0.05   0.07   0.08   0.08    0.1    0.1

See Also

@COMPOUNDGROWTH
@DECLINE

principalMbr	Single member specification that represents the initial value of the value to grow. The first nonzero value encountered is the initial value. Other principalMbr values after the first are ignored.
rateMbrConst	Single member specification, variable name, or numeric expression providing a constant value that represents the decimal growth rate to be applied (for example, 10% = .1).
rangeList	Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.