Essbase @COMPOUNDGROWTH

Calculates a series of values that represents a compound growth of values
(the first nonzero value in the specified member across the specified range
of members) across time.

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])
Parameter Description
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, 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",FY1998:FY2003);

This example produces the following report:

                 FY1998 FY1999 FY2000 FY2001  FY2002  FY2003
                 ====== ====== ====== ======  ======  ======
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