Group by and sum

(1) Share

Report

Posted on by BradLambie

Hi,

I have a collection with the following fields

Fabric	Cut Qty	Cut Length
Main	5	185
Main	2	181
Main	2	181
Main	3	185
Milton	4	238.5

I want to get the unique data considering fabric and cut length. Then sum the Cut Qty.

Output I am trying to achieve.

Fabric	Cut Qty	Cut Length
Main	8	185
Main	4	181
Milton	4	238.5

I have searched and am really struggling to grasp the concept. I know what I have below is long, but here is what I tried.

ClearCollect(combine_fabric,AddColumns(Fabric_Cuts,"Unique_Col",Fabric & Cut_Length));

ClearCollect(combine_fabric2,AddColumns(GroupBy(combine_fabric,"Unique_Col","NameGroup"),"total_cuts",Sum(NameGroup.Cut_Qty,Cut_Qty)));

Any help is greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Seems like you're trying to group the data by both fabric and cut length, then sum the cut quantity.

You're sort of on the right track, but your formula can be simplified.

Here's a way you can achieve it:

ClearCollect(colGroupedFabric, AddColumns( GroupBy(Fabric_Cuts, "Fabric", "Cut_Length", "GroupedData"), "SumCutQty", Sum(GroupedData, Cut_Qty) ) ); ClearCollect(combine_fabric, ForAll(colGroupedFabric, { Fabric: Fabric, Cut_Qty: SumCutQty, Cut_Length: Cut_Length } ) );

See if it helps @BradLambie

Was this reply helpful? Yes No
BradLambie 32 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much! Worked flawlessly and makes sense. Its funny how you can stare at something for hours be so lost. Then in 30 seconds its solved by someone else.

Really appreciate it 🙂

Was this reply helpful? Yes No