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