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.
@DISCOUNT (cashMbr, rateMbrConst [, rangeList])
|cashMbr||Member specification representing the value you want to discount from
the last period in rangeList to the current
|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
|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.
Financial functions never return a value; rather, they calculate a series
of values internally based on the range specified.
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