Results by Category and Month: calculation of working days per month.

[wgonzalez]

Hi,

I've created a bar chart showing %'s by month in each category.  I need to compute working days for each month as part of the % calculation.  The current expression (below) is calculating working days by the whole user selected time frame, not by each month.  Please advise.

sum(AttHours) / (((sum({$}EmpRecordCtr)*8) * NetWorkDays(MonthStart(min(DTPunchDate)),MonthEnd(max(DTPunchDate))))-sum(AttHours))

[#2]

im not sure what you got inside the chart

post sample file

[wgonzalez]

Here you go!  Each bar represents Hours Used % per month in each category.

To calculate the % I need to first calculate working days per month.  With the current formula (expression) I'm getting working days for the whole time frame selected by the user.

Thanks.