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

Selective Access user lookup?
@rob_marshall I feel like you would be able to answer my question, and if you can't then no one can. My question is - using selective access on a hierarchy level I want to be able to look up the user that has access to a particular level within the hierarchy so that I can create a standardized e-mail using the mailto…
Time Filter on Custom view in My Pages
I have difficulty with “Custom views” in Activities 13.6.5 and 13.9.3 where I select Custom View but cannot Filter Time Dimension. The instruction is "Filter: Time - show only Forecast Months" Could anyone please help on this issue.
Forecaster missing Error Messages and Stuck on Creation
Hi! I'm currently trying to set up an example for the forecaster and I'm running into various issues. At first (and I managed to resolve it by now) my data collection creation failed without any error messages. Next, after I managed to create it, my forecaster model is stuck on status 'creating' for 1.5 hours already. Is…