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



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 

Best Answers

  • ryan_kohn
    Answer ✓

    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!



  • ryan_kohn
    Answer ✓

    @neg177 Glad it worked for you! Can you mark my response as a solution? Thanks!


  • @neg177 Appreciate the blueprint and module views. For a question like this, it would be very helpful for you to share the formula you tried to write and what the error message was.


    Based on your description and module, it sounds like you want to SUM by Day Of Week and Month. You would need both these values stored at the Day level in order to SUM by them into your target module. I see also that you have Versions in your source model but not in your target module. You'll either need to SELECT a specific version in your formula or add Versions as a dimension in your target module, otherwise Anaplan will pick your Actuals version as the default.

  • neg177

    Here is the message error I get when I put in the formula in this screen shot. 



  • Okay, I tried replicate in my own model and was able to reproduce the error you are getting (note that I'm also SUMming by the Month in order to get the right value, as opposed to just the Day of Week).




    I spoke with a couple colleagues and we believe that the formula should work. My suggestion would be to submit a case to support@anaplan.com.


    I will also think about possible workarounds.

  • neg177

    We are trying this work around right now, but we have a quick question, how did you populate the Real Date LI? 



    Thank you 

  • neg177

     Your work around worked. Thank you very much