How to Group Weekly revenue into a customized Month (List)?

JaredDolich
Moderator

Re: How to Group Weekly revenue into a customized Month (List)?

@jimfeng5 

Okay! Now we're on to something.

Do you need to see that worked out in Anaplan, or do you think you've got it?

So, so cool! I just learned something new - Is that rule typical in the broadcasting industry?


Jared Dolich
jimfeng5
Certified Master Anaplanner

Re: How to Group Weekly revenue into a customized Month (List)?

@JaredDolich, yeah the broadcast calendar is uniform across the industry. Let me try to figure this out myself first. If I managed to figure it out, then I will post my solution up here, if I couldn't figure it out then I will ask you guys for help!
Amaya
Certified Master Anaplanner

Re: How to Group Weekly revenue into a customized Month (List)?

Hi, Jim @jimfeng5 
 
I think I understood that logic! (I love this kind of a puzzle 😉
 
The Broadcast Month seems to be determined by the month of the end date of weeks.
For example, the 35th week in 2020 is contained in August in the BM, because the week ends on 30th August.
Anaplan calendar 4-4-5 sets that week September.
 
(By the way, your image of the calendar has two 26th weeks ^^)
 
So, you have to check whether the end of weeks and the end of 4-4-5 months are the same dates. See below and attached.
 
BroadcastMonth.png
 
And I made a month dimensioned module and try x[SUM: Broadcast Month], but I was said that was illegal.
So, once you get Broadcast Month in this way, you have to make a "fake month" list to wrap up the result.
 
Or option B is the way of "Weeks count" in the module. Sum up next week's value into this month when next week is BM adjust week.
 
I hope I am correct and this helps you a bit.
 
Here is the time setting.
 
CalSet.png
 
 
 
 
Regards,
Taichi