Announcements
Hello everyone,
I've got a formula that calculates the total cost based on item prices, using the following formula:
Text( Sum( Filter( 'Food prices', 'Food choice' in ThisItem.'Food Option'.Value ), Price ) * ThisItem.'Number to be catered for', "£#,##0.00" )
The "Food prices" section in SharePoint currently looks like this:
I also have a tracker SharePoint list that records entries, including the account.
Now, I'm looking to generate a breakdown within a gallery, displaying all the account areas and their corresponding costs calculated per account.
Any assistance or guidance on achieving this would be appreciated. Thank you!
Hi @AB1,
This isn't something I've tried so no guarentee it'll work but I'd try something like this:-
Sum(Filter('Tracker', Account=ThisItem.Account), LookUp('Food Prices',ThisItem.'Food Option'='Food Choice', 'Price'))
Where would I add this formula?
Into the Text element of a text label within a gallery item. I've used similar code which has worked before so hopefully it'll do what you want it to.
dont think the formula works and I need to work out the total cost for each account.
Ie Users spent £100 in Maths (choice in account column) and £120 in English (choice in account column)
Does this make sense?
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 542 Most Valuable Professional
Haque 206
Kalathiya 201 Super User 2026 Season 1
