cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pricey79
Helper V
Helper V

Using SUM function help please

Hello everyone, I was hoping someone could help me please

 

I have a Sharepoint list called Cost with 2 columns,  item name and costs 

I have a label in my app, that I would like to show the sum of all costs associated with a gallery that is filtered to the current logged in user.

So for example,  if I were logged in the gallery would show all my items , and I would like the label to show the sum of all item costs.

The gallery is called Gallery_Myitems

 

I then have this on the label, but it doesnt work. I've never used the sum function before so was hoping someone could help please?
Sum(Filter(Costs , Cost ,Gallery_Myitems.AllItems)

 

Thank you in advance

22 REPLIES 22
eka24
Super User
Super User

On the Gallery, change the formula to:

Filter(AddColumns('Sharepoint1',"Cost",LookUp(Cost,Title='Sharepoint1'[@Equipment],Cost)), Contact = User().FullName)

 

Then in your Label:

Sum(Gallery1.AllItems,Cost)

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

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.

Consider Checking My Youtube Channel

 

@eka24 

Amazing, thank you. That works

@KvB1 Thank you so much for your time. I've accepted the solution further down the page. Thanks again

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (5,335)