Sum selected values in a list.( Somma valori selezionati in una lista.)

[anonymous]

how to get the Sum of selected values in a list.

[Marc_Dillon]

How are you selecting them?

[Swoopy]

Try SUM( …your old expression…)

[anonymous]

not work. thank

[anonymous]

I select rows on a view. thank

[Aurelien]

Hi @TonyB

You may want to apply bulk action, like “make part of the sum”: yes or no’ and apply your sum to these rows.

Depending on your need, you will then make an expression such as:

SUM(
  SELECT(yourTable[yourColumnToSum], 
    [partOfSumCalculation]
  )
)

For reference:

SUM() - AppSheet Help

SELECT() - AppSheet Help

Use bulk actions - AppSheet Help

[anonymous]

I select rows in a view with 5 column. Only 1 column have numerico value.

Brunasso Cristofaro
Via Nino Bixio 10 - 10092
Beinasco (TO)
Tel. 3425795508

[Aurelien]

Hi @TonyB

You could try this option if that makes sense to you:

or, with the Bulk Action way:

Basically this is made of these columns:

And the SUM() expression is this one:

SUM(
  SELECT(PRODUIT[Price],
    [sum?]
  )
)

[anonymous]

The second solution is ok.
So on the google sheet (PRODUCT) there are 2 columns named Price and Sum?.
Did you create an action with that syntax after that?

[Aurelien]

@TonyB

So on the google sheet (PRODUCT) there are 2 columns named Price and Sum?.

yes

@TonyB

Did you create an action with that syntax after that?

This one:

[anonymous]

But on the column sum?, i must insert this sintax? =FALSE()

[Aurelien]

No, just the initial value should be set as FALSE in your Sheets.

[anonymous]

Sorry but not work. i have build this:

1. worksheet named [Elencospese] with 3 columns [Dettaglio], [€], [Calcola]

2. The column [Calcola] containe the value [FALSE] only first row

3. I have build a View [Elenco spese]

4. I have build a action [Sommatoria]

something is missing? Thank

[Aurelien]

Yes.

Check the option “SHOW” for the column rownumber.

Add this column in your view Sommatoria if you still don’t see it

And set the view name with the sum expression, in the Appearance section (make sure to select the flask icon)

[anonymous]

2 questions:

1. is the name of the view correct?:

=“Sommatoria” & =SUM(SELECT(List of expenses[€],[Calculate]))

2. adding the icon switch next to the column “€” the values ​​disappear.

[Aurelien]

Hi @TonyB

Just type this, without any equal sign:

"Sommatoria" & TEXT(SUM(SELECT(List of expenses[€],[Calculate])))

[anonymous]

can you ti sendme your app, for to control the differenze with my app. My app not work

[Aurelien]

Expression:

"SUM prices= " & TEXT(SUM(SELECT(PRODUIT[Price],[sum?])))

[anonymous]

Thank! Now work.

[Viet]

But it takes time to sync how can I do it immediately