Sum work houers

[Langemyr]

I have a list in sharepoint an want to display sum of users workhouers pr. project for logedin user.

The table look like this:

When user1 start the app i want to display in a gallery, his workhouers.

like this

Any ideas?

[RandyHayes · Accepted solution]

@Langemyr 

You can utilize the GroupBy function for this and then add a column to your resultant table with the sum.

Ex.

AddColumns(
    GroupBy(
        Filter(yourDataTable, user=loggedInUserName),
        "user",
        "_recs"
    ),
    "hourSum", Sum(_recs, hours)
)

I hope this is helpful for you.

[Langemyr]

Fantasic 🙂

but i gruped by project 😉

[Langemyr]

now im going to sort witch projects i have worked on an how many houers each day 😉

[RandyHayes]

@Langemyr 

Yes, sorry, I meant to group by Project and not user.

For the daily sums, you will need to employ the same grouping concept except you will group on the Date instead.