Previous list item in formula

LucaRicci

Hello,

Is there a way to assign a value depending on the previous list item?

In my case, I need to assign the value 1 to the week 5, value 2 to the week 6 and so on until week 9. The values always go from 1 to 5, however the week number might change (for instance, choosing RFC24/01, value 1 is to be assigned to week1 ecc)

I tried to use the codes of the week but it does not seem to work.

Thanks in advance,

Luca

TristanS

@LucaRicci you can use the Previous function https://help.anaplan.com/previous-e5806da3-1ae6-4b45-9e02-68ac764cb97d for this intention

Add another line item "Sequence counter"

Formula would be Previous(Mapping) + Mapping

LucaRicci

@TristanS Ok, I tried but it gives me the same number repeatedly. Just so you know, the line item "mapping" has been formatted as a list containing the items 1,2,3,4,5.

TristanS

LucaRicci my bad it should be Previous(Sequence Counter) + Mapping

And mapping should be set to 0 instead of blank … is it a text. Change it to number

LucaRicci

@TristanS Sorry, I still get the same result (I need that list for a following module, so I can't change it completely)

TristanS

LucaRicci wait … Week 1, Week 2 is a list .. thought it was time period … try Cumulate(VALUE(NAME(Mapping))) then. Just to clarify, FY24 dropdown is actually a time period right or is it another list?

LucaRicci

@TristanS Yes, FY24 is a time period. Still nope though: