Unanswered

Calculations within a Galley

(0) Share

Report

Posted on by itsmejojo

Hi everyone,

A bit new to Powerapps and I am trying to use an operator to calculate a result on 2 fields within each record (in the gallery) and then sum the column of the results.

I need to calculate 2 fields within the gallery and then I need to to sum them. There are 12 of these fields so didn't really want to put labels if I could avoid it as it would be additional 12 labels, and this will need to be used on multiple screens.

Also to note - I don't need to save any of these calculations, they are just needed to then go on to determine some further outcomes which will then be saved.

e.g

Field1 Field2 Field3 Field4 Field5 etc etc

2 3 4 5 6

3 4 5 6 7

For each Row I need to perform a operation on each of these 12 fields to get a result

Field 1 * Field2, Field 1 * Field 3, Field 1 * Field4 etc

6 8 10 12

12 15 18 21

Then I need to Sum the results of each column

18 23 28 33

Thanks for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

BelgianDev 53 on at

Like (0)

Report
Copy link

Link copied!

So you want a calculated field displayed in your gallery?

You can add a new label and put it's Default to "ThisItem.Value1 + ThisItem.Value2"

I'm not sure if I understood your question correctly, but this would be my solution for from what I understand is your isse

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,
If you are using a gallery and you want to calculate sum of all items in a column named Quantity, you can use below formula
Sum(Gallery1.AllItems, Quantity)

Was this reply helpful? Yes No
itsmejojo 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the replies and sorry if I wasn't clear, have amended the original post.

Was this reply helpful? Yes No