Avatar

Level 1

I would like to build a daily target. I have monthly target of 100%. Data indicates that in average Monday, Tuesday and Thursday deliver 25% of Monthly target each and the rest 25% is divided with the rest of the days. I calculated the average from 3 months and made sure that each weekday was present same amount of times.

Since amount of weekdays is changing by the month I cannot use static number like 4. If I use COUNT IF day=Monday function in early Feb it would give me 0 or 1 depending if there has already been 1 Monday.

So if I want to calculate target for all Mondays in Feb (before Feb is completed):

100%*0.25 / COUNT Mondays (in Feb this translates to 0.0625) but in April the number would be 0.05 since there are 5 Mondays in March.

Even though Adobe prints all dates from Feb it does not seem to be able to calculate how many Mondays there is going to be. Counting weekdays works fine if I calculate the target for January, but that kinda defeats the purpose.

I have now resorted adding the number as a static value but if you guys have any suggestion I welcome them gladly.