I think you need to try calculating the week hours sum directly in the employee table. This way, it will be easier for you to achieve your goal.
Thank to this, in the report you will be able to add a condition, something that would sound like:
“if weekHoursSumForThisEmployee >0, then display informations”
For your formula, I think you are close to it.
In the expression you captured, you will want to change it to embbed the Employee Name, and change your strategy in order to loop from the Employee Table.
- You add a Virtual column in the Employee Table, to get all related time log from the last week:
Related lastWeekLogs Expression:
- You add a new Virtual Column, in your employee table, and name it SumWeekHours.
SUM([Related lastWeekLogs][Total Hours])
In addition, please find some useful information here:
- Once you are done with it, we can start the next step.
Assuming you loop your start statement on the employee table, the template expression will probably look like this:
Total hours a week : <<[SumWeekHours]>>
Time in:<<[Time in]>>
In addition, documentation here:
Let us know if that works for you
EDIT : I noticed I misunderstood something and changed my post according to my new comprehension