Hi! I am worked on a timesheet report for weekly hours worked for a group of field technicians. I have created a slice that filters the punch in/punch out times for each employee. A report prints every Monday showing the work times for each day the previous week. This all works. I have a virtual column in the timesheet table that calculates the total hours worked for each employee the previous week. This also outputs the correct info. This issue I have is that that โTotal hours workedโ prints out in the report the same number of times as the number of rows in the report. So, for example, if the employee had 5 days of punch in and out times the previous week, the total number of hours for those 5 days will print out 5 times. Is there a way to print out the sum once instead of printing to match the number of rows in the report?
Thanks!
Justin
Solved! Go to Solution.
Can you try the following.
<<Start:FILTER(Total hours worked in past week for Rob, true)>>
Date: <<[Date]>> Time in: <<[Time in]>> Time out: <<[Time out]>>
<<End>>
Total hours: <<SUM(SELECT(Timesheet[Number of hours], AND(([Employee name]=โRob Grawbergerโ), ([Date] > (TODAY() - WEEKDAY(TODAY()))), ([Date] <= (TODAY() - WEEKDAY(TODAY())) + 7))))>>
I am not very good with expressions, but I think your expression will compute the total correctly if you put it in the Report template (as shown above). If so, and if you donโt use that virtual column elsewhere, it would be better to compute the total in the Report and eliminate the virtual column from the slice.
User | Count |
---|---|
43 | |
26 | |
25 | |
16 | |
13 |