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?

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

MarkWarren

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.

James Dougan

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

Azure SQL Connection, database name with Hyphens in Data Orchestrator
I am attempting to connect to an azure SQL database vis at the MSSQL connector in data orchestrator but am having issues and I believe it is due to hyphens in database name (which is a fairly standard naming convention I will note!) Example below (fake credentials) - has anyone else encountered similar and is there a way…
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…