Business days in a month during a year (Networkday)

[Ari_vzla]

Hi guys, 

 I have troubles with a graph, I need count the field "Qty" per month and divided between days of the month, and if the month in not complete, divide until last day of the month. For example, September has 3 days, and the sume of this 22 days is 2900,  I need divide this quantity between business day of the month (3), the value to graph in september will be 132, but the sum of Octubre is 13273 but up today we have 12 days, the result will be 1106, octuber will be graph 1106, in that way with the rest of the month in a year.

I tried with:

Count([Confirmation time])/NetWorkDays(MonthStart([Picks per day 2020. Creation Date.autoCalendar.YearMonth]), MonthEnd([Picks per day 2020. Creation Date.autoCalendar.YearMonth])

Confirmation time is the value that I need count, and creation date is my calendar, and include the no working days, but as result of networkday is always 22. 

What I need fix to get the network days or the days in a month correctly in a range of date?

Date	Qty	Business day in month	Total Value
28/09/2020	876	3	967
29/09/2020	965
30/09/2020	1059
01/10/2020	1290	12	1106
02/10/2020	1028
05/10/2020	1162
06/10/2020	1202
07/10/2020	1538
08/10/2020	1095
09/10/2020	934
12/10/2020	670
13/10/2020	860
14/10/2020	1058
15/10/2020	1347
16/10/2020	1089

[Kushal_Chawda]

@Ari_vzla  try below

Data:
LOAD Date, 
     Qty, 
     MonthName(Date) as Month
FROM FROM;

=sum(total <Month>Qty)/Count(total <Month>Month)