@DISCOUNT

This 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 [, XrangeList])

Parameters

cashMbr

Member specification representing the value you want to discount from the last period in XrangeList 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.

XrangeList

Optional parameter specifying the period over which the discount is calculated. If a range is not specified, Essbase uses the level 0 members from the dimension tagged as Time.

Can be a valid member name, a comma-delimited list of member names, cross dimensional members, or a return value from a member set function or range function (including @XRANGE).

For more information about rangeList and XrangeList, see Range List Parameters in the topic Range and Financial Functions.

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

The following example assumes a Year dimension is added to Sample Basic. It calculates discount using a multidimensional range.

FIX ("100-10", "New York")
"Discount Amount" = @DISCOUNT(Cash,"Credit Rate",@XRANGE("2011"->"Sep", "2012"->"Mar"));
ENDFIX

The above calculation is performed across the following multidimensional range specified by XrangeList:


2011->Sep
2011->Oct
2011->Nov
2011->Dec
2012->Jan
2012->Feb
2012->Mar