I know that I can use this value expression to get me the work hours for the current week.
.valueexpression=DIV(WORKMINUTESDIFF($$TODAYew,$$TODAYbw),60)
However, I am building a report allow the user to select the date range they want and group by the week. In the group heading, I would like to show the number of work hours for the group by week. I was hoping that this would work. It does not.
DIV(WORKMINUTESDIFF({entryDate}ew,{entryDate}bw),60)
Would anyone have insight?
I was hoping to generate a report where the user could see their direct reports times and see if they've entered all hours in the week. For example this week, they would be required to enter 40 hours, while next week it will show 32 hours.
Thoughts?