Month days calculation

[My_Rebecca]

Is there any expression to calculate how many days in one month?

In my previous post, I have following bottle neck to calculate the month days while select different time period for max date minus min date. Look forward to find the answer here.

Previous post: Solved: Re: Productivity Calculation - Page 2 - Qlik Community - 2058015

This time the scrip is loaded successfully, but how to use this variable correctly? I write the expression: Count(distinct(GI_Delivery & [GI_Delivery Item]))/(7*8*(NetWorkDays('$(=vProductivity_MinDate)','$(=vProductivity_MaxDate)')

But this expression does not work, the calculation result is incorrect while filtering. What is the reason?

The total productivity (1.6) are divided by FY22 & FY23 (1.1+0.5).  Obviously this is wrong. The correct result should be almost equal to 1.6 no matter which year, quarter, month are filtered.

[stevedark]

Hi @My_Rebecca 

I have posted some pointers over on the previous post:
https://community.qlik.com/t5/New-to-Qlik-Sense/Productivity-Calculation/m-p/2058488#M227864

Steve

https://www.quickintelligence.co.uk/blog/