Advise on building methodology

neg177
neg177
in Modeling

Hi, 

 

Im trying to build out in Anaplan a way to take all the totals of the first day of each month and then divide it by the totals of the whole month. This will give me a ratio that is needed to multiply by each dayified first day of the month. 

 

Thank you 

Tagged:

Answers

  • JaredDolich
    JaredDolich

    @neg177 

    Neg! How've you been? You deserve the Community award for most participation. Great question.

    Easy to handle by the way. Two methods:

    • MONTHVALUE
    • system module that is set to the day level. Create a line item formatted as a period (month) and use the PERIOD(START()) function to identify the month. Then in your planning module you can LOOKUP the month value that way.
  • neg177
    neg177

    Hi Jared, 

     

    I believe I have my SYS modules already set up to do so, (Ill add a screen shot of them), but what I'm trying to do overall is dayify a monthly number that is in one of my modules, and then take the dayified first of the month totals, (excluding Weekends and Holiday's), and then divide those dayified first of the month totals by the month total. 

    Trying to take this monthly total 

    neg177_0-1659116621078.png

    Use Simple math to break apart the Monthly number in accordance to days of the week

    neg177_1-1659116747371.png

     

    Then in this module it will be daily and I only want to look up the amount of every first day of the month

    neg177_2-1659116845816.png

     

    SYS Modules 

    neg177_3-1659116928238.png

     

     

     

  • MarkWarren
    MarkWarren

    What is the select in Funding Dayification Totals?
    (You should just put that formula in Funding Dayification Daily, no need to "daisy chain" it.)
    It looks like you recreate the value of D04 Total Funding on C06b, and just copying it across Days.

Categories