Alternative week List - How do i retreive

DeveloperCYT

Hi,

 

We have a customer who have an alternative week description, their year runs from March to March, so their week 1 is ANAPLAN's week 9 for example.

I have created a list 'Weeks' and this has the 'Reak week' and also the alternative week (currently in text)

Then in my module i want the Alt Week to show... but i do not know how to LOOKUP this using the period , time, week ????

 

 

Any help or guidance would be appreciated, even if it is a simpe,as it seems...

 

Thank you

 

Jaakko

Hi,

If there is a logical way to conclude the correct member from alt weeks list, you could use finditem-function to automate the mapping. If there is no formula for that, I would probably build the mapping in excel, save that as csv or txt and would import it to module. If imported data includes the exact names or codes of your alt weeks list, Anaplan will populate the dropdown lists with the values. You can also use the weeks list as a source for the import action.

 

If you want to sum the alternative weeks to a higher level, build a parent hierarchy for alt weeks list or create additional list formatted line items to the mapping module that you can use with SUM: in your formulas.

 

Br,

Jaakko