You’re offline. This is a read only version of the page.
I have a gallery connected to a collection. I'm trying to groupby facilitator and sum their duration to show number of hours delivered.
I have grouped the facilitators ok using this formula on the gallery:
Share
ReportSortByColumns(GroupBy(AddColumns(FT,"Facilitator",Facilitator1.Value),"Facilitator","FAC1"),"Facilitator",Ascending)I'm unsure how to include the Sum on the Duration field.
Example of data:
Joe Bloggs 1.5
James Test 1
Joe Bloggs 3
What i want the gallery to show is:
James Test 1
Joe Bloggs 4.5
Is this possible and can someone advise please?
thanks
Alistair
@neill_long
Put this code in the Items property of your Gallery. It will add a new column for the sum called Sum Of Value
All responses (
Answers (
SortByColumns(
AddColumns(
GroupBy(
AddColumns(FT,"Facilitator",Facilitator1.Value),
"Facilitator","FAC1"
),
"Sum Of Value", Sum(FAC1, Duration)
),
"Facilitator",
Ascending
)
Then create a new label in your gallery with this code in the Text property
ThisItem.'Sum Of Value'
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
On the Gallery Items:
AddColumns(GroupBy(
AddColumns(FT,"Facilitator",Facilitator1.Value),
"Facilitator","GroupedFaci"),
"SumValue",Sum(GroupedFaci,DurationColumn))
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
HI,
Put a text box or label outside the gallery and [Sum( "Gallery_name", "Field")]
I will send more information directly
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
