nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pull data into current year from previous year where both are list items

How do I pull data into current year from previous year where both are list items and both are used in a module?

Tags

Modeling

Calculation Functions

Accepted answers

What codes are you using for the list items?

You can map the 2 lists together either by automating the mapping: Jan = 1 Feb = 2 and so on then use a finditem on this code?

All comments

What do you mean when you say they are both used in the module?
Do you have "current year" and "previous year" line items?
If you are using a list to represent time, these line items being list formatted, you would need an IF statement to check if your list item matched the "previous year" item and then pull the data from "current Year".

You should be considering using native Time though where functions like PREVIOUS() can quickly reference periods, in this case dimensioned by Years.

What codes are you using for the list items?

You can map the 2 lists together either by automating the mapping: Jan = 1 Feb = 2 and so on then use a finditem on this code?

Quick Links

Can you help?

Unanswered questions

Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…