250
Hey Power-Helpers,
I have a little difficulty doing this, i have a SharePoint list that i need to sum up values with only corresponding ID from a collection.
DETAILS:
Collection (COLL_ZONE)
| ID_Evaluation_ES | Statuts.Value |
| 1a | VALIDE |
| 2s | DRAFT |
| 1z | DRAFT |
| 1q | VALID |
Table (Responds_Evaluation)
| ID_Evaluation_ES | Value |
| 1a | 20 |
| 2s | 58 |
| 1z | 20 |
| 1q | 54 |
How do i get the value of all [VALID] ID please?
Thank You.
First you can filter your collection by "VALID" , then you can use AddColumns to your collection so that it kinda does a lookup for the values. Then sum them all. Try something like this:
Share
Report
All responses (
Answers (
Sum(
AddColumns(Filter(COLL_ZONE,Statuts.Value="VALID"),"Value",LookUp(Responds_Evaluation,ID_Evaluation_ES = ID_Evaluation_ES)),
Value)
