Answered

Calculate the sum of each row based on the column in Power Apps.

(0) Share

Report

Posted on by Az8PnG

Hi there,

I am having some difficulties on creating the formula to calculate the sum of of each rows (Quantity) based on the columns (Part Number) and store the total sum in column named "Total Quantity".

Ex: Part Number = E-000001, Total Quantity is 27.

Can anyone help me on doing this, because I didn't found any tutorial on this. Thanks in advance.

Stock In Latest.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Verified answer

Samuel-Zhou 393 on at

Like (1)

Report
Copy link

Link copied!
@Az8PnG Hi,You can try this Code,

Sum(Filter('list_name', Part Number = "E-000001"), Quality)

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report
Copy link

Link copied!

Hello Mr @Samuel-Zhou , thanks for your help.
How about if I wanted to find the sum for every part number?How was the formula is going to look like?

Was this reply helpful? Yes No
Samuel-Zhou 393 on at

Like (1)

Report
Copy link

Link copied!
@Az8PnG Hi,you can try this code,

GroupBy( SortByColumns( 'Your SharePoint List Name', "Part Number", Ascending ), "Part Number", "Part Number Sum", Sum(Quality) )

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report
Copy link

Link copied!

Thank you Mr @Samuel-Zhou .

My code is:
GroupBy(SortByColumns('StockInLatests',"cre39_partnumber",SortOrder.Ascending),"cre39_partnumber","cre39_totalquantity",Sum(ThisItem.Quantity))

I am having some error in this code which are:
and

May I know why is this errors occurs?

I will show you my column name as well:
1. For Part Number
2. For Quantity
3. For Total Quantity

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report
Copy link

Link copied!

Thank you Mr @Samuel-Zhou .

My code is:
GroupBy(SortByColumns('StockInLatests',"cre39_partnumber",SortOrder.Ascending),"cre39_partnumber","cre39_totalquantity",Sum(ThisItem.Quantity))

I am having some error in this code which are:
and

May I know why is this errors occurs?

I will show you my column name as well:
1. For Part Number
2. For Quantity
3. For Total Quantity

Was this reply helpful? Yes No
Samuel-Zhou 393 on at

Like (0)

Report
Copy link

Link copied!
@Az8PnG Try this,

AddColumns( GroupBy( AddColumns( StockInLatests, "Part Group", 'Part Nubmer', "Quan", ThisRecord.Quantity ), "Part Group", "Quan" ), "QuanSum", Sum( ThisRecord.Quan, Quantity ) )

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report
Copy link

Link copied!

Hi @Samuel-Zhou just try the code above. I just can't fix the problem yet. Do you mind if we discuss about this maybe in teams or skype?

Was this reply helpful? Yes No
Samuel-Zhou 393 on at

Like (0)

Report
Copy link

Link copied!

@Az8PnG Hi,we can use private message to discuss

Was this reply helpful? Yes No
Az8PnG 85 on at

Like (0)

Report
Copy link

Link copied!

Hello@Samuel-Zhou do u received my message?

Was this reply helpful? Yes No