Which field is [Capital 2014 Capital])?
irr([[set_expression] total [<fld {,fld}>] ] expression)
returns the aggregated internal rate of return for a series of cash flows represented by the numbers in expression
iterated over the chart dimension(s). These cash flows do not have to be even, as they would be for an
annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. The internal
rate of return is the interest rate received for an investment consisting of payments (negative values) and
income (positive values) that occur at regular periods. The function needs at least one positive and one negative
value to calculate. Text values, null values and missing values are disregarded. See also the rangeirr(
value { ,value} ) (page 313) function.
Expression must not contain aggregation functions, unless these inner aggregations contain the total qualifier.
For more advanced nested aggregations, please use the Advanced Aggregation (page 291) function in
combination with calculated dimensions, see Add calculated dimension... (page 614).
If the word total occurs before expression the calculation will be made over all possible values given the current
selections but disregarding the chart dimension variables.
The total qualifier may be followed by a list of one or more field names within angle brackets. These field
names should be a subset of the chart dimension variables. In this case the calculation will be made disregarding
all chart dimension variables except those listed, i.e. one value will be returned for each combination
of field values in the listed dimension fields. Also fields which are not currently a dimension in a
chart may be included in the list. This may be useful in the case of group dimensions, where the dimension
fields are not fixed. Listing all of the variables in the group causes the function to work when the cycle or
drill-down level changes.
Examples:
irr( Payments )
irr( X*Y/3 )
irr( total Payments )
irr( total <Grp> Payments )
