Calculate classic month summaries in week model

hamzaghazilabassi

Hello,

 

I have a model set with a week 4-4-5 model calendar. In this model I created a module where I input the team presence per day.

 

 My issue is that I would like to calcule number of days worked per month, I mean from the 1st to the 30th and not by week as it sums up days from prior months (see image).

 

On the image, Anaplan shows 17 days for november because it considers 24th of October as the 1st day of november and the 18th November as the last day (red rectangle). I would like, in an another module of course, to display 20 days (cells highlighted).

 

Thanks

Misbah

@hamzaghazilabassi 

 

See if this helps

Convert Values from a 445 Calendar to a Normal, Mo... - Anaplan Community

 

Misbah

Miz Logix