Answered

Sum of DataField in BrowseGallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

How to calculate Sum of all DataField from browsegallary. I have tried using formula

Sum(TextBox3)

but it is fetching only first card value . It is not taking values for all card. Suggest some help

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Steelman70 873 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi, if I understood you question correctly, you should insert a text box outside the data gallery and set its text property to Sum(Source, DataField). Please see this example:

PS The Text( ... , "#,###.00") around the sum is just for formatting

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have filterd the datasource on BrowseScreen. Now I want calculate the result based on filtered data that currently showing on BrowseScreen

Was this reply helpful? Yes No
Verified answer

Steelman70 873 on at

Like
a
(3)

Report
Copy link

Link copied!
How about Sum(Filter(Source, XXX > YYY), DataField) where XXX > YYY is the same filter condition as the gallery?

Alternatively you can:
Put your filtered records in a collection with ClearCollect
Set the Items of your gallery to this collection
Set the sum text box to show the sum of the collection's data field
What is the event/trigger for the filtering of the data source?

If you post some screenshots or formulas it may be easier to help you.

Was this reply helpful? Yes No
audrieFCT 987 on at

Like
a
(0)

Report
Copy link

Link copied!

I was trying to do this too. Did you get an answer outside of the forum on how to perform a SUM based on a filter? (I don't have a gallery in my case, I'm just summing data from a data source.)

Was this reply helpful? Yes No
rgruian Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Audrie,

Assuming for example you have a data source "ShoppingCart" with at least one numeric column e.g. "Price", and you want to sum over a filtered view of the the data source, e.g. if Price < 1000:

= Sum(Filter(ShoppingCart, Price < 1000), Price)

Alternatively you can also fold the filtering logic into the aggregator itself:

= Sum(ShoppingCart, If(Price < 1000, Price, 0))

Please do keep in mind however that aggregators such as Sum, Average, etc -- are not yet delegated to the data service back-end. This means they can only operate on up to 500 rows of data at the moment, until PowerApps gets aggregate query delegation support.

Was this reply helpful? Yes No
audrieFCT 987 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you.

Do you know if "aggregate query delegation support" is planned this fiscal year or not?

Was this reply helpful? Yes No
rgruian Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

We are actively working on this feature. We will ship it as soon as it's finalized and deemed rock-solid.

Thanks for your patience.

Was this reply helpful? Yes No
audrieFCT 987 on at

Like
a
(0)

Report
Copy link

Link copied!

MVP it man! (Perfection is over-rated) Smiles

Thanks for all of your help!

Was this reply helpful? Yes No
Phyre 2 on at

Like
a
(0)

Report
Copy link

Link copied!

You need to be specific about the column name.

This works as follows:

Sum(Collection; [@ColumnName]) - Comma separators don't work for me (en-ZA)
~ or ~
Sum(Collection, [@ColumnName]) - Comma separator seems commonplace for all other users

Was this reply helpful? Yes No
mkujalowicz on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
Im not sure if there was an update for this topic, but none of the above solutions worked for me as I imagine that I delegate the 'Sum' opertation to the data source with the filters applied in the gallery. The error message I get is the following:
Part of this formula cannot be evaluated remotely.'Sum' operation is not supported by this connector/service.

What I try to achieve is to sum gallery items based on the filters set in two dropdowns, something similar to SUBTOTAL in Excel.
Please help.
Thanks!
Magda

Was this reply helpful? Yes No