How to get previous value of line item which doesn't have time dimension

Hi,

I have a use case where I'm using the custom time dimension list in which there is a line item called Beginning balance which is the previous value of the Ending Balance.

So I'm stuck as there is not native time dimension being used in the module so I can't use previous function of Anaplan.

Any work around is possible?

I have attached screenshot for reference

Accepted answers

All comments

ChrisStauffer

Riyaz,

This post may give you some ideas on how to get previous value of line item without using time dimension:

https://community.anaplan.com/t5/Anaplan-Platform/Trick-Previous-on-regular-list-sequential-calcs-using-time-as/m-p/64483

Chris Stauffer

mburdak

Hi @riyazpasha ,

This post is very similar to yours, hopefully the same trick will be helpful for you too:

Solved: Re: Use "Previous" with non-timescale dimension - Anaplan Community

Regards,

Mandeep Burdak

ManjunathKN

Hi

There is no formula that can achieve this right now.

you need to use a system module and make mapping for previous and use this as lookup for your beginning inventory.

Thanks,
Manjunath

riyazpasha

Hi @mburdak ,

Can you please send a screenshot of Dynamic weeks. I think its list and you are using lookup for list property.

If you can send me the screenshot of like how you have configured previous week that would help.

Thanks

mburdak

Sure here's the grid view:

and the properties tab:

I have used the code itself but you can also create a property called Week Number to do this calculation if you need code for something else.

Regards,

Mandeep Burdak.

riyazpasha

Hi @mburdak ,

But in my case its the dates, the logic that you have applied for the weeks is sequential but for dates any idea how to use your logic as there no pattern in dates its on adhoc basis.

riyazpasha

Hi @mburdak

I followed your solution and built the same logic using RANK function but when I want to lookup the Ending balance with previous ATD date, I'm getting circular reference error.

I have attached the screenshot.

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…