- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
So currently:
Yearly target: 100
Monthly multiplier (towards yearly goal): 0.1
Target for this month: 10
Number of each weekday in this month: 4 (February is easy)
Multipliers for each weekday:
Mon: 0.25
Tue: 0.25
Wed: 0.09
Thu:0.25
Fri: 0.04
Sat:0.06
Sun:0.06
Monthly and weekday multiplier were calculated based on last year performance
So my target for
1st of Feb (Friday) would be
100*0.1*(0.04/4) = 0.1
2nd of Feb (Saturday)
100*0.1*(0.06/4) = 0.15
3rd of Feb (Sunday)
100*0.1*(0.06/4) = 0.15
4th of Feb (Monday)
100*0.1*(0.25/4) = 0.625
5th of Feb (Tuesday)
100*0.1*(0.25/4) = 0.625
6th of Feb (Wednesday)
100*0.1*(0.09/4) = 0.225
7th of Feb (Thursday)
100*0.1*(0.25/4) = 0.625
So the problem was that I cannot get the number of each weekday in a month dynamically.
COUNT only returns number of Mondays from the past. for example if date is 8th of Feb COUNT returns 1
Any comments?
Views
Replies
Total Likes