Lag Function without Time Demensions

felixchu · 2023-02-08T16:29:10+00:00

There was an error rendering this rich post.

Hi Anaplanners,

I am trying to model a queue building up in Anaplan and I am wondering if there is any way I can use the Lag function to return the adjacent value without time dimensions. The principle is to add the queue from the previous segment and add to the current segment, however the model does not have any time dimension, so there is an error when using the Lag function.

I was trying to use Lookup but it caused a circular reference.

Any ideas on how to use Lag function without a time dimension will be much appreciated.

Thanks,

Felix

Accepted answers

rob_marshall

@felixchu

Sorry, but LAG(), Previous(), Next() only work with native time...Something to think about is having the calculations using the native time functionality and then referencing the results via a mapping module using lookups.

Not saying this link is your silver bullet, but it might give you an idea. Flexible Time

AjayM

Hi @felixchu ,

I hope this workaround gives you some alternate idea to your requirement, if not exactly the same. A couple of things to please note:

Codes of Segment list items, or the list against which you do the calculation has to be in a sequence
This is not exact replacement to LAG functionality

Workaround:

My Segment list items have codes in a sequence, that are helpful enough to find previous item for every list item
I have two ways of cumulating the values here - one that adds previous segment value to current segment value, the other that cumulates segment values along the Segment list

Cheers!

All comments

rob_marshall

@felixchu

Not saying this link is your silver bullet, but it might give you an idea. Flexible Time

AjayM

Hi @felixchu ,

I hope this workaround gives you some alternate idea to your requirement, if not exactly the same. A couple of things to please note:

Codes of Segment list items, or the list against which you do the calculation has to be in a sequence
This is not exact replacement to LAG functionality

Workaround:

My Segment list items have codes in a sequence, that are helpful enough to find previous item for every list item
I have two ways of cumulating the values here - one that adds previous segment value to current segment value, the other that cumulates segment values along the Segment list

Cheers!

felixchu

Hi @rob_marshall ,

Thank you for the suggestion. As a workaround, I created the date and map the column header to the date so I can now use the Lag () function.

Thanks

felixchu

Hi @AjayM ,

Thank you for the suggestion.

I did give it a goal but unfortunately it is causing circular reference as I had formulas built in the previous lookup.

As a workaround, I created the date and map the column header to the date so I can now use the Lag () function.

Thanks

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…