Unanswered

Display sum of a column all the values in gallery

(0) Share

Report

Posted on by MAli_Ch

I have a column A. I'm able to display the change in its value in gallery before saving it into the DB using the following code.

If(IsBlank(LookUp(MyCollection, ID = ThisItem.ID).A),
ThisItem.A,LookUp(MyCollection, ID = ThisItem.ID).A)

Just for reference, MyCollection the collection where change in value is stored. A is the col where value is changed.
Now I have a col B in my gallery only where I want to display the sum of all the values of col A. I also want to capture the live value(like if value of col A is changed in a row then sum in should also be changed in gallery before saving anything in DB).

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

MudassarSZ365 591 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MAli_Ch ,
In your gallery, create a label where you want to display the sum.
Set the Text property of this label to the following formula:
Sum(MyCollection, A)
If you think my solution is helpful for you, then please accept it. 😊

Was this reply helpful? Yes No
MAli_Ch 95 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MudassarSZ365
The sum you mentioned will only show the collection values sum. I need sum of values which are in collection(changed values) + sum of value which are not in collection(unchanged values).

Was this reply helpful? Yes No
MudassarSZ365 591 on at

Like
a
(1)

Report
Copy link

Link copied!
@MAli_Ch ,
First, create a new collection that combines the original data source with the changes from MyCollection. This collection will have the latest values for each item, whether changed or unchanged.

ClearCollect(CombinedCollection, ForAll(YourOriginalDataSource, If(IsBlank(LookUp(MyCollection, ID = ID)), {ID: ID, A: A}, {ID: ID, A: LookUp(MyCollection, ID = ID).A} ) ) )

Now, use this CombinedCollection to calculate the sum. In the label where you want to display the sum, set the Text property to:

Sum(CombinedCollection, A)

If you think my solution is helpful for you, then please accept it. 😊

Was this reply helpful? Yes No