web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calculating and Displa...
Power Apps
Unanswered

Calculating and Displaying Cost Breakdown in Gallery

(0) ShareShare
ReportReport
Posted on by 394

 

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: 

 

Screenshot 2023-11-29 at 09.37.16.png

I also have a tracker SharePoint list that records entries, including the account.

Screenshot 2023-11-29 at 09.37.46.png

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!

 

Categories:
I have the same question (0)
  • Sickle-Cell Profile Picture
    600 Super User 2024 Season 1 on at

    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'))

  • AB1 Profile Picture
    394 on at

    Where would I add this formula? 

     

     

  • Sickle-Cell Profile Picture
    600 Super User 2024 Season 1 on at

    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.

  • AB1 Profile Picture
    394 on at

    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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard