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

[TonyB]

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

[Marc_Dillon]

How are you selecting them?

[TonyB]

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

[TonyB]

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

[Swoopy]

Try SUM( ...your old expression...)

[TonyB]

not work. thank

[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?]
  )
)

[TonyB]

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 wrote:

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

---

yes

---

@TonyB wrote:

Did you create an action with that syntax after that?

---

This one:

[TonyB]

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.

[TonyB]

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)

[TonyB]

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])))

[TonyB]

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

[Aurelien · Accepted solution]

Expression:

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

[TonyB]

Thank! Now work.☺️

[Viet]

How can I change it immediately it took a while to sync then return the value

[Viet]

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

[Aurelien]

---

@Viet wrote:

How can I change it immediately it took a while to sync then return the value

---

Hi @Viet 

You need to use a virtual column for instantaneous computation.

[BayuBiru]

@Aurelien 

If you don't mind, can you explain more about the virtual column to avoid the sync 

thank you

[Aurelien]

Hi @BayuBiru 

Here is the documentation: 

Use virtual columns - AppSheet Help

Columns: The Essentials - AppSheet Help

[BayuBiru]

@Aurelien 

Thanks,

I have read it, but which column should be virtual to avoid the Sync when the button was pressed?

[Aurelien]

The one you wish to have calculated "on the fly".

It's a column you will add to your table, using this button:

[BayuBiru]

Okay, I just success following your tutorial, only have a problem with Sync,

so the display name formula 

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

 the [Price] and [sum2] is a virtual column?

in Action it cannot set some value in Virtual column

[Aurelien]

An action WON't update a virtual column, as it is virtual.

Please create a separate thread in the Q&A section to avoid any confusion with the initial post 🙂

[BayuBiru]

Okay, thank you