So currently:Yearly target: 100Monthly multiplier (towards yearly goal):
0.1Target for this month: 10Number of each weekday in this month: 4
(February is easy)Multipliers for each weekday:Mon: 0.25Tue: 0.25Wed:
0.09Thu:0.25Fri: 0.04Sat:0.06Sun:0.06Monthly and weekday multiplier were
calculated based on last year performanceSo my target for1st of Feb
(Friday) would be100*0.1*(0.04/4) = 0.12nd of Feb
(Saturday)100*0.1*(0.06/4) = 0.153rd of Feb (Sunday)100*0.1*(0.06/4) =
0.154th of Feb (Monday)100*...
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
I'm trying to get the number of Mondays in this month (February).Today
is the first Monday of Feb so any way I try I get value 1.The goal would
be to get value 4 which is the number of Mondays.Any ideas?