Calculates the Internal Rate of Return on a cash flow that must contain at least one investment (negative) and one income (positive) value.
@IRR (cashflowMbr, discountFlag[, rangeList])
cashflowMbr | Single member specification. |
discountFlag | Member specification, variable name, or numeric expression providing a constant value of either 1 or 0. discountFlag indicates whether the function should discount from the first period. 1 means do not discount from the first period. |
rangeList | Optional. A valid member name, a comma-delimited list of member names, member set functions, and range functions. If rangeList is not specified, Analytic Services uses the level 0 members from the dimension tagged as Time. |
This example calculates the Internal Rate of Return (Return) on a cash flow (Cash).
Return = @IRR(Cash,0,FY1998:FY2000,FY2001:FY2003);
This example produces the following report:
FY1998 FY1999 FY2000 FY2001 FY2002 FY2003 ====== ====== ====== ====== ====== ====== Cash (1,000) 500 600 500 #MISSING #MISSING Rate 0 0 0 0 #MISSING #MISSING Return 0 0 0 0 0 0
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |