@COMPOUNDGROWTH

This function 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 [, XrangeList])

Parameters

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.

XrangeList

Optional parameter specifying the time period over which the interest is calculated. If a range is not specified, Essbase uses the level 0 members from the dimension tagged as Time.

Can be a valid member name, a comma-delimited list of member names, cross dimensional members, or a return value from a member set function or range function (including @XRANGE).

For more information about rangeList and XrangeList, see Range List Parameters in the topic Range and Financial Functions.

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

The following example assumes a Year dimension is added to Sample Basic. It calculates compound growth using a multidimensional range.

FIX ("100-10", "New York")
"Compound Growth" = @COMPOUNDGROWTH("Principal Amount","Growth Rate",@XRANGE("2011"->"Sep", "2012"->"Mar"));
ENDFIX

The above calculation is performed across the following multidimensional range specified by XrangeList:


2011->Sep
2011->Oct
2011->Nov
2011->Dec
2012->Jan
2012->Feb
2012->Mar