Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Calculating summary totals

Posted on 27 Nov 2024 17:24:50 by 25
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.AllItemsHours)
 
What formula do I have to enter so that each persons total hours for the week is displayed? Thanks in advance.
  • RobElliott Profile Picture
    RobElliott 9,965 on 27 Nov 2024 at 17:42:44
    Calculating summary totals
    You use & not +. So it would be something like 
    "Total Hrs " & Sum(galHours.AllItems,Hours) & " hours"
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,137

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,813

Leaderboard