PREVIOUSITEM() formula which is like PREVIOUS() but references a list item instead of time

Hi Anaplan, 


I was searching for the use of the PREVIOUS function but on a list item but it is not currently possible. 


@peter_mcanena has suggested this but only in a discussion thread. 


So as his idea suggests:


PREVIOUSITEM(x, y) where

  • x: Any expression
  • y: List

The expression x must be based on the list y. PREVIOUSITEM(x, y) would then pick up the value of x from the previous item in the list y.


Anaplan would need to allow PREVIOUSITEM(x, y) to be used in the definition of x itself, in the same way as PREVIOUS(), without creating a circular reference.


full thread here:


It would be great if this was developed! 





Community Manager
Status changed to: Needs Community Support
Regular Contributor
Status changed to: Under Investigation
Users Online
Currently online: 175 members 430 guests
Please welcome our newest community members: