how do i sum all based on the condition in gallery?

(0) Share

Report

Posted on by ntt56k4

219

Hi Folks,

I have a gallery links to SP list and the list contains a Total and Cost Center columns. I have a hard time figuring out the correct formula to sum a specific cost center. Below is an example of what it looks like

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

zmorek 3,272 on at

Like (0)

Report
Copy link

Link copied!

Sum(Filter(ListName, 'Cost Center' = "A"), Total)

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Insert a Label and on the Text property:

Sum(Filter(Table1,CostCenter= Gallery1.Selected.CostCenter),Total)

Thus whichever cost center is selected in the Gallery, it would be summed.

------------

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.

Was this reply helpful? Yes No
ntt56k4 219 on at

Like (0)

Report
Copy link

Link copied!

ok thanks but I don't want to sum everything on the sharepoint. I Just want to sum what is on the gallery since the gallery filters based on the selected date drop down.

Was this reply helpful? Yes No
ntt56k4 219 on at

Like (0)

Report
Copy link

Link copied!

thanks but unfortunately I need to display the total from each cost center in the gallery because the gallery is filter from the date selected drop down.

Was this reply helpful? Yes No
ntt56k4 219 on at

Like (0)

Report
Copy link

Link copied!

I tried the formula below and is not working

Sum(Filter(Gallery, 'Cost Center '="A"),Total)

What I am really looking is to display each cost center with the total amount on another Gallery, rather than creating separate label for each cost center to show the total for each cost center...

Was this reply helpful? Yes No
ntt56k4 219 on at

Like (0)

Report
Copy link

Link copied!

I also tried below and is not working either

Sum(Filter(SPList, Gallery.AllItems,'Cost Center '),Total)

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Have you tried the solution I gave:

Sum(Filter(Table1,CostCenter= Gallery1.Selected.CostCenter),Total)

------------

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.

Was this reply helpful? Yes No
ntt56k4 219 on at

Like (1)

Report
Copy link

Link copied!

yes the formula below works but it only shows the total cost center amount from the selected item in Gallery, but rather I would like to display the total for each cost center without having to select the item in the gallery.

Sum(Filter(SPList,CostCenter= Gallery1.Selected.CostCenter),Total)

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report
Copy link

Link copied!

Insert a Gallery and put this formula on the Items Property:

AddColumns(
GroupBy(Datasource,"CostCenterColumn","SumT"),
"Totals", Sum(SumT,TotalColumn))

------------

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.

Was this reply helpful? Yes No
ntt56k4 219 on at

Like (0)

Report
Copy link

Link copied!

thanks again but it won't recognize the cost center column nor the total column.. It shows a list of Cost Center datacards and Total datacards and not the column itself.. I really don't mind creating a separate label for each cost center to get the total for each cost center if it makes it easier.

Was this reply helpful? Yes No