@COMPOUNDGROWTH

The @COMPOUNDGROWTH() function calculates a series of values that represent a compound growth of the first nonzero value in the specified member across the specified range of members. The growth factor is calculated by multiplying the growth rate in the current time period by the previous period's result, yielding a compounded value. You can change the growth rate from period to period by placing a nonzero value in the current period's rateMbrConst cell.

Syntax

@COMPOUNDGROWTH(principalMbr, rateMbrConst [, rangeList])

principalMbr Member specification representing the initial value to be compounded. The input line must be a single deposit.

rateMbrConst Single member specification, variable name, or expression which provides a constant value. This value can change across rangeList, making the new value be the new compound rate. If the value in the current period is zero, the compound rate is equal to zero, and the principal does not change.

rangeList Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the dimension tagged as Time. 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 determines the compound growth of Principal Amount based on Growth Rate across a series of fiscal years.

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

This example produces the following report:

                 FY1991 FY1992 FY1993 FY1994  FY1995  FY1996
                 ====== ====== ====== ======  ======  ======
				 
Principal Amount  2,000  2,000  2,000  3,000  2,500   -500
Growth Rate      0.0525      0      0      0      0      0
Compound Growth   2,105  2,105  2,105  2,105  2,105  2,105

See Also

@GROWTH

principalMbr	Member specification representing the initial value to be compounded. The input line must be a single deposit.
rateMbrConst	Single member specification, variable name, or expression which provides a constant value. This value can change across rangeList, making the new value be the new compound rate. If the value in the current period is zero, the compound rate is equal to zero, and the principal does not change.
rangeList	Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions from the dimension tagged as Time. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.