Calculate classic month summaries in week model

edited November 2022 in Modeling



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).