Compiles the proceeds of a compound interest calculation. The calculation is based on the balances of the specified member at the specified rate across the specified range.


@COMPOUND (balanceMbr, rateMbrConst [, XrangeList])
Parameter Description


Single member specification representing the beginning balance across a range of periods. The input can be either one deposit or a series of deposits. If balanceMbr is a constant, then Essbase assumes balanceMbr to be a single deposit in the first member of rangeList or XrangeList. This is equivalent to entering the constant value in the first member in the range followed by zeros. The function keeps track of each deposit separately, but returns a composite value. If balanceMbr is a member, or a range, then it is assumed to be a series of deposits.


Single member specification, variable name, or numeric expression in decimal form. This represents the interest rate per time period specified in the rangeList or XrangeList. If your interest is compounded monthly, this value would be the annual interest rate divided by 12.


Optional parameter specifying the range over which the interest is compounded. The last value in the range is the total compounded interest for that range. 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.


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


The following example determines the compound interest of a series of deposits, based on a credit rate of 0.0525, across a series of fiscal years:

"Compound Interest"=@COMPOUND(Deposit,"Credit Rate",FY1998:FY2001,FY2002);

This example produces the following report:

               FY1998   FY1999   FY2000   FY2001   FY2002
               ======   ======   ======   ======   ======
Credit Rate    0.0525  0.0525    0.0525   0.0525    0.0525
Compound Interest   0     105  110.5125 273.8144  288.1897
Deposit             0   2,000         0    3,000         0

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

FIX ("100-10", "New York")
"Compound Interest" = @COMPOUND(Deposit,"Credit Rate",@XRANGE("2011"->"Sep", "2012"->"Mar"));

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


See Also