Essbase @DISCOUNT

Calculates a value discounted by the specified rate, from the first
period of the range to the period in which the amount to discount is found.
The answer is returned in the same period. More than one value can be discounted
simultaneously in this manner.

Syntax

@DISCOUNT (cashMbr, rateMbrConst [, rangeList])
Parameter Description
cashMbr Member specification representing the value you want to discount from
the last period in rangeList to the current
period.
rateMbrConst Member specification, variable name, or numeric expression which provides
a constant value. The value represents the rate per period which cashMbr is discounted. It is a decimal value, not
a percent.
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 discounts the values in Cash by the rates in Credit
Rate and places the results in Discount Amount for each fiscal year.

"Discount Amount" = @DISCOUNT(Cash,"Credit Rate",FY1999:FY2002,FY2003);

This example produces the following report:

                    FY1999  FY2000  FY2001  FY2002  FY2003
                    ======  ======  ======  ======  ======
Cash                  0.00    0.00 1000.00 1000.00    0.00
Credit Rate           0.00    0.00    0.05    0.05    0.00
Discount Amount        #MI     #MI  863.84  822.70    #MI