Solved: Re: Combine Two Rows and Sum the Values

Tameron · 06-25-2024 08:34 PM

I trying to create an action that combines the values of two selected rows. In other words, when I multi-select two rows and press the Combine action, I would like the action to create a new row and sum the values in Column 1. Is this possible?

This is the expression I used:
CONCATENATE(SELECT(Untitled spreadsheet[Test 1], ([Test 1] = [_THISROW].[Test 1])))

I know I'm totally off with the expression but I'm not sure what to use. Thank you for any help.

jaichith

I have changed few things in the test app which you have shared. changes are listed below

1. You had hidden the edit action, but I have made it visible.

2. I have added the "Combine Column (Enum list)" to the quick edit columns. This allows you to add a list of rows to be combined from the detail view of a particular row/record.

3. A new action named "Set or Clear the Enum Columns to blank" has been created.

4. The new action type was set to "Set values to some columns of this row":
- Column "combine" was set to "" (blank).

5. A group action named "Add Row & Combine row and clear Enum column" was created.

6. The "Add Row & Combine" action was added as the first action, followed by "Set or Clear the Enum Columns to blank" as the second.

7. The following actions were hidden:
- "Add Row & Combine Set Values"
- "Set or Clear the Enum Columns to blank"

8. The group action "Add Row & Combine row and clear Enum column" was set to be prominent.

Now your need may be satisfied !!!. Welcome to appsheet community.

thank you

View solution in original post

VarunChandran

No issues with the Action which you have created. If the Test 1 column type is number then

in the Expression use this Test 1 = Sum(Table Name[Test 1]). Select Primary Position for this Action.

To perform this action when you select multiple rows refer this

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Select-items-actions/m-p/768957#M247169

Tameron

Thank you very much for your reply. The Expression is close to what I am looking for.

However, I added another row to test the process. The combine action is adding together all of the Test 1 column's rows (10 + 5 + 10 = 25). I only want the rows that are selected to be added together (10 + 10 = 20). I would also like to have just one new row, not new two rows.

jaichith

@VarunChandran wrote:
Test 1 = Sum(Table Name[Test 1]).

This expressions adds/sums all values of the column.

My suggestions. You can create an actions from a row.

Add a Column to a table with name[ Combine values / rows]. make the column as Enumlist

you can use the action which created already but change the expression alone

sum(select([tablename[combine/row],in([keycolumn],[_thisrow].[combine/row])))

and

column [combine/row] will have the valid if expression

select(tablename[keycolumn],true)

you will get the dropdown to select the rows to be added.

Tameron

Thank you for the idea here. However, I tried the expression but I get the following error: "SUM function requires a list of numeric inputs". I changed my columns to Number but it still has not worked. Did I do something wrong with the expression?

Tameron

Enumlist base type is also set to number

jaichith

It need not base type of number. Combine column helps to select the columns that's all.

jaichith

Is this action expression or column expression ?

jaichith

sum(select([tablename[test1],in([keycolumn],[_thisrow].[combine/row])))

sorry try above expression. and revert back. I will guide you step by step and another thing you may be need to do to reset the [Combine/row] column to blank " " with the help of set values to some columns of this row and group action. This I will tell you later because it may confuse you. Please try first set of suggestions and update me the progress of it

Tameron

Thank you for the idea here. However, I tried the expression but I get the following error: "SUM function requires a list of numeric inputs". I changed my columns to Number but it still has not worked. Did I do something wrong with the expression?

@jaichith wrote:
Is this action expression or column expression ?

sum(select([tablename[test1],in([keycolumn],[_thisrow].[combine/row])))

This is the action expression. Does it go in the action expression or the column expression?

Tameron

I tried the new expression but still I cannot get the results or dropdown

jaichith

You cannot select the rows in table view. You want to select the values from enum list and while dressing the action. It will create new row.

Tameron

I'm sorry but I do not understand. Which view do I use? I really appreciate your time on this. Can you please explain the process, perhaps with pictures?

jaichith

Text me privately.

jaichith