Looking up Day of the Week list for a LI in a different module

neg177

Hi, 

I'm trying to be able to look up a total for all the individual days of the week from my historical data. i.e, I would need to look up all the Mondays in the Month of July and sum them together. I have weekdays as a list but I'm getting a error message when I try to use LOOKUP, SELECT, or SUM. Please advise. 

Blue Print 

 

 

 

Thank you 

ryan_kohn

I have a possible workaround for the issue you're running into by leveraging a Fake Time list for Days.

 

In this example, I've built a list called Fake Time Day by importing a code for the Day and a mapping to a real time Day. Note that within Anaplan, there is no "Day" list format available, but you can use a date-formatted item in the same way (in majority of cases).

 

My Fake Time Day list looks like this:

 

I also have System modules for attributes for native Days as well as Fake Time Days. See below for example from my Fake Time Days module. Note that I am doing a LOOKUP on the Real Date line item, which is date-formatted!

 

In my example, I entered some dummy data in a module dimensioned by native Days:

 

And then I used a LOOKUP from my System module above to get that data into a module dimensioned by Fake Time Days:

 

When I do this, I'm able to use the attributes from Fake Time Days to get the result I'm looking for:

 

 

 

Hope this helps!