Unanswered

Sum function in a collection

(0) Share

Report

Posted on by ekoz21

Hi!

I have a Gallery which has a record of item prices. The records to the gallery are added from a form. I am trying to write a sum function that would display the total sum of item prices:

I used the following formula:

"Total Sum, Eur: "& Sum(ColStolenArticles, Value(Suma_lbl.Text))

However, I keep getting a blank outcome. Any help is much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Sid_Jafri 478 on at

Like (1)

Report

Hi @ekoz21 ,

You better use the collection value and sum up. e.g. use the collection column name for unit price and amount
"Total Sum, Eur: "& Sum(ColStolenArticles, unitprice * amount)
Or you can use
"Total Sum, Eur: "& Sum(Gallery.AllItems, Value(Suma_lbl.Text))

Make sure that Suma_lbl.Text doesn't contains text value as I seen above have some text of Sum, Eur:
Please Thumbs up and accept as solution if my post helped you solve your issue.

Was this reply helpful? Yes No
Verified answer

Dipak_Shaw 108 on at

Like (1)

Report
Hi,
if you want to sum the items of a gallery outside the gallery.
You should use
"Total Sum, Eur: "&Sum(Gallery1.AllItems,SumPrice)
Where -
Gallery1 = Your gallery name.
SumPrice = The Field that you want to sum.
Try it out, It will definitely work.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No