cancel
Showing results for
Did you mean:
Frequent Visitor

## Sum of a calculated/lookup column

Dear Community

Problem
I want to display a total of all entries in a calculated column (Amount)

Setup:

SP List: Report:

 Title Hours Price Text Text Text Hans 2 5 Max 2 10

SP List: Customers

 Title Price Text Text Hans 5 Max 10

Powerapp: Gallary1:

 Title Hours Price Amount Text report.hours Lookup(Customers, ThisItem.Title = Title).Price Hours * Lookup(Customers, ThisItem.Title = Title).Price Hans 2 5 10 Max 2 10 20

Now i want a Text Label who SUM all Items in the Gallary Row "Amount" (10+20 = 30)

I cant do SUM(Gallary1.Allitems,Amount) because the Amount row has no Name ist calculatet (Hours * Price)

Thanks !

Levin

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

I think I have an idea of what you are asking, and that this example should help you figure it out

In the above gallery I have the items from TestColl which is a test collection I made with this as its items

``Collect(TestColl,{Value1:1,Value2:10},{Value1:4,Value2:7},{Value1:3,Value2:20})``

the third label in the gallery is just the two items multipled.

In the label off to the right of the screenshot above you have the sum of all the multiplications in the gallery, achieved like so

``````Sum(
ForAll(
Gallery5.AllItems,
Value(ThisRecord.Title7_1.Text)
),

Value)
``````

where gakllery5 is my gallery, and Title7_1 is the control where the multiplication takes place

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!
3 REPLIES 3
Super User

I think I have an idea of what you are asking, and that this example should help you figure it out

In the above gallery I have the items from TestColl which is a test collection I made with this as its items

``Collect(TestColl,{Value1:1,Value2:10},{Value1:4,Value2:7},{Value1:3,Value2:20})``

the third label in the gallery is just the two items multipled.

In the label off to the right of the screenshot above you have the sum of all the multiplications in the gallery, achieved like so

``````Sum(
ForAll(
Gallery5.AllItems,
Value(ThisRecord.Title7_1.Text)
),

Value)
``````

where gakllery5 is my gallery, and Title7_1 is the control where the multiplication takes place

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.
This helps others find solutions to future issues!
Super User

@Premium Gallery' main function is to display data from the source.. now in your case the Amount that you are calculating is on the fly..  what's the Gallery' Items Property.?

Frequent Visitor

Thanks @TheRobRush this is exactly what I needed.It's really extreme how quickly help is given here, and probably voluntarily... That's very nice to see

greetings from Switzerland

Announcements

#### Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

#### Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

#### Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,760)