Essbase @GROWTH

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

This example produces the following report:

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