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

Like (0) Share

Report

Posted on 25 May 2023 07:20:57 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

All responses (9)

Answers (1)

Az8PnG 85 on 30 May 2023 at 07:38:43

Like (0)

Report

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

Hello@Samuel-Zhou do u received my message?
Samuel-Zhou 393 on 30 May 2023 at 01:11:27

Like (0)

Report

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

@Az8PnG Hi,we can use private message to discuss
Az8PnG 85 on 30 May 2023 at 00:09:40

Like (0)

Report

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

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?
Samuel-Zhou 393 on 26 May 2023 at 04:15:08

Like (0)

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

@Az8PnG Try this,

AddColumns( GroupBy( AddColumns( StockInLatests, "Part Group", 'Part Nubmer', "Quan", ThisRecord.Quantity ), "Part Group", "Quan" ), "QuanSum", Sum( ThisRecord.Quan, Quantity ) )
Az8PnG 85 on 26 May 2023 at 03:19:35

Like (0)

Report

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

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
Az8PnG 85 on 26 May 2023 at 03:19:30

Like (0)

Report

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

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
Samuel-Zhou 393 on 26 May 2023 at 01:23:06

Like (1)

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

@Az8PnG Hi,you can try this code,

GroupBy( SortByColumns( 'Your SharePoint List Name', "Part Number", Ascending ), "Part Number", "Part Number Sum", Sum(Quality) )
Az8PnG 85 on 25 May 2023 at 12:47:58

Like (0)

Report

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

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?
Verified answer

Samuel-Zhou 393 on 25 May 2023 at 07:48:12

Like (1)

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

@Az8PnG Hi,You can try this Code,

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