RESOLVED Hey everyone, I have a time-sheet app I’m putting together for my team.
I have a slice of my timesheet data I created for the previous week’s punches. I then have the data grouped by [Email] and then by [Time Type] (Time type is used to differentiate between overtime and regulartime hours)
I’d like to use the group aggregate to display the sum of the sub-group [Time Type], but the only option I’m presented with is “Count”.
Can anyone shed some light on this or offer an alternative way to sum durations based on three sorting criteria (Week Number, Email column, Time type column)?
Thanks for your time!
Edit: Just realized I posted this to the app design heading, I can delete and repost correctly if mods decide that’s the right thing to do