Summary total data for entries

(0) Share

Report

Posted on by BillZab

I have a Timesheet App and I would like to create a Summary screen that shows the individual total of each hour worked by each employee. I have the following formula in a text field, but instead of showing the total for each individual, it shows the total of all entries:

"Total Hours: " & Sum(Filter([@Timesheet], ThisItem.employee, Hours),Hours)
 
Where am I going wrong? It appears that the filter is not working on the 'Hours' field as this totals up everyones hours and not each individual.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
Hi @BillZab

Try this:

"Total Hours: " & Sum(Filter([@Timesheet], employee = ThisItem.employee, Hours),Hours)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Thanks,
ANB

Was this reply helpful? Yes No