Get previous Item in current list

ArthurA
ArthurA
edited February 25 in Modeling

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.

image.png

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

image.png

here is my module.

image.png
image.png

Best Answer

  • devrathahuja
    devrathahuja
    Answer ✓

    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! :)

Categories