Get previous Item in current list

Atz1234

Hi everyone, in Time period, i can use PREVIOUS() function. In my module, i dont have time period so i created a list which has Week 1 to Week 52.

if data from module cash balance is 0, then previous ending balance will become the beginning balance. but it gives me error.

here is my module.

devrathahuja

Hi @ArthurA ,
You cannot create recursive calculations with a non-time list.

The easiest way to go across this would be to map your custom list of Week 1 to Week 52 to a native time list & do the calculations there & pull it back to this one.

You can create a time range for just 1 year, map the week 1 to week 52 using formulas to the native time & then pull the source values to time, calculate your balances, pull it back to custom list.

Hope this helps! :)