What i need to do is show a sum of the number values for each Team Member, for the date ranges between StartDate and EndDate.
Essentially what I want to make possible, is for the user who is inputting a teams time entries to be able to quickly view a summary of their employees, and see their total hours for the current pay period, to ensure no one is missing hours.
The column names and types are:
- 'Team Member' - Single Line of Text
- 'Date Worked' - Date
- 'Project Worked' - Single Line of Text
- 'Regular Hours Worked' - Number
- 'Overtime Hours Worked' - Number
- 'Double Time Hours Worked' - Number
- 'Sick Hours' - Number
- 'STAT Hours' - Number
- 'Vacation Hours' - Number
The formula I have for the blank gallery (which is not working), is:
AddColumns( GroupBy( Filter( 'Time Sheets', 'Date Worked' >= StartDate.SelectedDate && 'Date Worked' <= EndDate.SelectedDate ), 'Team Member', "GroupedItems" ), "TotalRegularHours", Sum(GroupedItems, 'Regular Hours Worked'), "TotalOvertimeHours", Sum(GroupedItems, 'Overtime Hours Worked'), "TotalDoubleTimeHours", Sum(GroupedItems, 'Double Time Hours Worked'), "TotalSickHours", Sum(GroupedItems, 'Sick Hours'), "TotalSTATHours", Sum(GroupedItems, 'STAT Hours'), "TotalVacationHours", Sum(GroupedItems, 'Vacation Hours') )
Any help on what I’m doing wrong? Is there a better way to acheive this?