Looping in Anaplan

hi @PujithaB 

I would say that you need to create a module with the time dimension and one line item for each item in your formula:

• OPEN BALANCE CF Inc/dec in Receivables
• CLOSING BALANCE CF Inc/dec in Receivables
• Customer Accounts Receivable
• Other Receivables
• Accounts Payable - Intercompany

Then use the function PREVIOUS (most likely, else try POST or OFFSET).

Finally, in order to avoid the loop, I suggest to break down the formula into 2 items: Open Balance for Receivables and Closing Balance. It will look something like this:

OPEN BALANCE CF Inc/dec in Receivables = previous(Customer Accounts Receivable)+previous(Other Receivables)-previous(Accounts Payable - Intercompany))

CLOSING BALANCE Inc/dec in Receivables = OEPN BALANCE CF Inc/dec in Receivables -((Customer Accounts Receivable)+(Other Receivables)-(Accounts Payable - Intercompany))

Please, let me know if it helps.

Cheers,

Alex

Olivehorse