Answered

Sum function in a collection

Like (0) Share

Report

Posted on 7 Jul 2021 04:00:35 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!

All responses (2)

Answers (2)

Verified answer

Dipak_Shaw 108 on 07 Jul 2021 at 04:20:41

Like (1)

Report
Re: Sum function in a collection

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.
Verified answer

Sid_Jafri 478 on 07 Jul 2021 at 04:13:41

Like (1)

Report

Re: Sum function in a collection

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.