Thanks for the reply! I am aware of the IRR function and have been using it.
The issue though is related to the fact that for the Excel IRR function you can select any part of the cashflow (up to previous period, current period, etc) whereas for Anaplan there is no option to select just a part of a cashflow.
Hi, you can set the 0 the values that are outside the period you want.
let's say you have a line item called "cash flow" with all the cash flows for all periods. Create a second line item called "Specific Period Cash Flow" and a third one "Valid Period" (as a boolean). The formula of "Specific Period Cash Flow" should be:
IF Valid Period then cash flow else 0
The only other way to play with Time and IRR is to use the IRR date settings (cash flow, date, dimension) but for that you need to have your cash flows as "transactions"