Avatar

Level 1

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?