sum of value selected

AppSheet AppSheet Q&A
1

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

2

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](AppSheet function list - AppSheet Help 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])).
1 Like
3

Don’t post your question twice.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Sum-selected-values-in-a-list-Somma-valori-selezionati-in-una/td-p/523514

2 Likes
4

Sorry