How to add sum of column numbers to a gallery?

(0) Share

Report

Posted on by Ginko

221

I am fully prepared for this to silliest question I ever ask if its something simply I'm overlooking.

Sum(Filter(Results,ItemNumber.Text in ThisItem.ItemNbr),ItemCount)

I want to pull the sum of ItemCount per ItemNbr from the datasource 'Results'. I have this within a gallery because I want the respective ItemCount per unique ItemNbr. However, what I'm getting from this formula is a repeating total sum of ItemCount for all rows in 'Results'.

What am I overlooking here? How can I achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Ginko,

Could you please share more about your data source?

Do you want to sum the ItemNbr based on your Filter result?

You could only sum each item within a column or a column within a table. The formula you provided will always sum the result retuning from the Filter() function.

Was this reply helpful? Yes No
Ginko 221 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi,

The data source is an excel spreadsheet on Sharepoint. The rows are generated from user submissions via Patch function within the app. The user inputs a numeric ItemCount into a text label in the app, and the rest is auto-patched via ThisItem results in the gallery.

I want to sum the below ItemCount, by ItemNbr. For example the sum of MM021527 would be 34. I want that 34 to be displayed for MM021527 in the gallery, 16 for CAR00179, 21 for MED00929 and so fourth.

Does this help? Based on the second half of your reply, is the sum function not able to handle what I am trying to achieve?

Was this reply helpful? Yes No
Ginko 221 on at

Like
a
(0)

Report
Copy link

Link copied!

Bumping this, anyone know how to SUM (for example) Column Y for an individual item from Column X?

Was this reply helpful? Yes No