I would like to request help with the following problem. I need to divide the sales objective by the number of business days in the month, the problem is that I can't sell half a car. The idea is to have only integers and the remainder must eventually be considered.
Please see the example (made poorly by hand):
August 2022
Sales Objective
01
02
03
04
05
08
09
10
11
12
15
16
17
18
19
22
23
24
25
26
29
30
31
40
1
2
1
2
2
2
1
2
2
2
1
2
2
2
1
2
2
2
1
2
2
2
2
55
2
2
2
3
2
2
2
3
2
2
3
3
2
2
3
3
2
2
3
3
2
2
3
20
0
2
0
2
0
2
0
2
0
0
2
0
2
0
2
0
2
0
2
0
1
0
1
Please note that the monthly target and number of business days change every month.
@Hans Vogelaarand I also must have been working on the problem in parallel. I did it a little differently. See my example! I did not want to throw it in the trash.
