CUBEXIRR

Only Executes Under: Cards

Calculates the extended internal rate of return for a series of cash flows at irregular intervals.

js

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

CUBEXIRR(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 time dimension.
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 XIRR. (optional)

Examples

js

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

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