I think it works well when we have 4 weeks in a month, however there are months with 5 weeks. Thus I would like to turn my formula into : "IF "number of weeks in month" = 4 THENMONTHVALUE('DEM01 Volume Growth Rates'.Growth %) / 4 ELSE MONTHVALUE('DEM01 Volume Growth Rates'.Growth %) / 5"
My problem is that I don't know how to count the number of weeks in the months (without pointing a specific month). Could anyone help me on that? (Or maybe I'm doing it all wrong and I need to use a completely different formula...😅)