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

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:

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/PREVIOUSITEM-PREVIOUS-on-a-list/m-p/33...

 

It would be great if this was developed! 

 

Thanks,

 

Usman

3 Comments
Community Manager
 
Status changed to: Your support is needed
Regular Contributor
 
Status changed to: Under Investigation
Certified Master Anaplanner

Another vote for this functionality.  This would be useful for creating any time based calc, instead of using time, one could create a calculation grid over a serialized list.

Users Online
Currently online: 195 members 1,071 guests
Please welcome our newest community members: