Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
im not sure what you got inside the chart
post sample file
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.