Hi. I have a timesheet app that works great with around 10 people entering their working hours on a daily basis. The timesheet is cleared down at the end of each week. I would like to add a summary page view that displays the total hours worked for each individual in the week. The 2 fields I have are 'Name' and 'Hours'. Using the groupby method I have a screen that lists each person with one or more entries in the excel data. However when I try to show the 'Hours' field it is blank and shows an error. I have tried the sum(thisitem.hours) command but it also gives an error. I use the following to total everyones hours:
"Total Hrs "+Sum(BrowseGallery1.AllItems, Hours)
What formula do I have to enter so that each persons total hours for the week is displayed? Thanks in advance.