Gallery Calculation in label

(0) Share

Report

Posted on by dursunzeeee

109

Hi ,

I could not do the Label 4 Calculation. Can you help me.

Gallery Powerapps.png

Categories:

Building Power Apps

I have the same question (0)

All responses (31)

Answers (4)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@dursunzeeee

Items property of your Gallery:

With({_items: yourCurrentItemsProperty}}, AddColumns(_items, "_sum", Sum(_items, Label_3ColumnName) ) )

Label_4 Text:

Text((ThisItem.Label3ColumnName / ThisItem._sum) * 100, "#%")

I hope this is helpful for you.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@dursunzeeee

For a more detailed explanation of how to set up a gallery in PowerApps see below. It has a calculation for a sum of the $ amounts in the gallery.

Was this reply helpful? Yes No
dursunzeeee 109 on at

Like (0)

Report

I cant "qty/allqty"

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@dursunzeeee

What is your Items property for the Gallery?

Was this reply helpful? Yes No
dursunzeeee 109 on at

Like (0)

Report

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@dursunzeeee

I am not understanding...you're not using the Items property that I suggested you should implement.

Your formula should be:

With({_items: Filter(Menu_Grup; Custom_Grup = Dropdown17_5.Selected.Result)}}; AddColumns(_items; "_sum"; Sum(_items; yourQtyColumnName) ) )

Replace yourQtyColumnName in the above with the name of the column in your datasource that you want to have the sum of.

For your Percentage column - this formula on the Text property:

Text((ThisItem.yourQtyColumnName/ ThisItem._sum) * 100; "#%")

And again, replace the column name in the above.

Was this reply helpful? Yes No
dursunzeeee 109 on at

Like (0)

Report

When gallery3_4 items write your code

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@dursunzeeee

Sorry, extra curly bracket in my last message:

Change to:

With({_items: Filter(Menu_Grup; Custom_Grup = Dropdown17_5.Selected.Result)}; AddColumns(_items; "_sum"; Sum(_items; yourQtyColumnName) ) )

Was this reply helpful? Yes No
dursunzeeee 109 on at

Like (1)

Report

Thank you very much for your support. I just started learning Powerapss.

Was this reply helpful? Yes No
dursunzeeee 109 on at

Like (0)

Report

Hello again, in the same way, if I need to do the second calculation, how should I proceed?

Was this reply helpful? Yes No