Sum of a calculated/lookup column

[Premium]

Dear Community

I need your help.. 🙂

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

[TheRobRush · Accepted solution]

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

[Sunil-Narnaware]

@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.?

[Premium]

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