@DISCOUNT

The @DISCOUNT() function 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])

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 from the same dimension. If rangeList is not specified, Hyperion 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",FY1991:FY1994,FY1995);

This example produces the following report:

                    FY1991  FY1992  FY1993  FY1994  FY1995
                    ======  ======  ======  ======  ======
				  
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

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 from the same dimension. If rangeList is not specified, Hyperion Essbase uses the level 0 members from the dimension tagged as Time.