CUBEIRR

Only Executes Under: Cards

Calculates the internal rate of return for a series of cash flows represented by the numbers in values.

CUBEIRR(cube, value_location, dimension, hierarchy, start_position, count, guess)

Parameters

• cube - Cube to look in.
• value_location - Location in cube to pull values from.
• dimension - The name of the dimension to iterate from.
• hierarchy - The name of the hierarchy.
• start_position - Position in hierarchy to start from.
• count - How many elements in hierarchy to include.
• guess - An initial guess at the IRR. (optional)

Examples

CUBEIRR("Profit and Loss", ["Amount"], "Time", "Month List", 3, 4)