Calculate values in a gallery

(0) Share

Report

Posted on by Oskarkuus

1,097

I have a gallery with numbers and category to each number.

How can i sum each row with category A and sum each row with category B and multiply each category C value with the current sum of a and b?

I need a code that work through each row in the gallery and do stuff based on what category each row have.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (2)

Report
Hi @Oskarkuus ,

I am a little confused with your description - is Category a number field? If so (and the same for B)

Sum( GalleryName.AllItems, CategoryA )

The total would be

Sum( GalleryName.AllItems, (CategoryA + CategoryB) * CategoryC )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
Hi @Oskarkuus ,

As @WarrenBelz said, your description is a little confused to me as well. Could you please share more details of your scenario? It would be much better for you to attach some screenshots and describe more clearly. I tried to make some assumptions however they all seemed not exactly meet your demand.

Below is one of those assumptions:

I have a list with a number column as well as a Category Choices column:

The label to display multiply results within the Gallery, Text property

If( ThisItem.Category.Value = "C", Sum( Filter( test1, Category.Value = "A" ), NO1 ) * Sum( Filter( test1, Category.Value = "B" ), NO1 ) * ThisItem.NO1 )

A Gallery connecting to this list, the Label displays the counting result:

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No