how to get the Sum of selected values in a list.
Solved! Go to Solution.
Expression:
"SUM prices= " & TEXT(SUM(SELECT(PRODUIT[Price],[sum?])))
How are you selecting them?
I select rows on a view. thank
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:
Try SUM( ...your old expression...)
not work. thank
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?]
)
)
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?
But on the column sum?, i must insert this sintax? =FALSE()
No, just the initial value should be set as FALSE in your Sheets.
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๐
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)
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.
Hi @TonyB
Just type this, without any equal sign:
"Sommatoria" & TEXT(SUM(SELECT(List of expenses[โฌ],[Calculate])))
๐ can you ti sendme your app, for to control the differenze with my app. My app not work๐ญ
Expression:
"SUM prices= " & TEXT(SUM(SELECT(PRODUIT[Price],[sum?])))
Thank! Now work.โบ๏ธ
How can I change it immediately it took a while to sync then return the value
But it takes time to sync how can I do it immediately
User | Count |
---|---|
33 | |
29 | |
29 | |
20 | |
18 |