sum of value selected

[TonyB]

I need to sum only a values selected in a table.

I select rows on a view connected a table with 5 columns (mytable) and only one column is numeric (mycolumn) 

I have tryed this sintax but non work. SUM(SELECT(mytable[mycolumn])).

thank

[dbaum]

---

@TonyB wrote:

I select rows on a view

---

How are you selecting the rows?

• If you're just using AppSheet's multi-select function in, say, a deck view there's no way to directly reference those rows in an expression. That functionality is for the purpose of performing an action on multiple rows, and is unrelated to the SELECT function.
• If you're representing row selection with row data (e.g., a [Selected] Yes/No column), then reference that in your SUM expression. For example: SUM(SELECT(mytable[mycolumn], [Selected])).

[Marc_Dillon]

Don't post your question twice.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Sum-selected-values-in-a-list-Somma-valori-sele...

[TonyB]

Sorry