Group by a Sum function in Power Query

[Anonymous]

In PowerQuery I try to sum the `quantité livrée`by `BL 2` (i have several rows with the same BL2 number but i can't delete doublons, regarding of details of the data)

The data looks like:

I tried:

=Table.Group(#"Somme quantité livrée", {"BL 2"},{{"quantité livrée", each List.Sum([#"quantitée livrée"]), type number}}

but the function doesnt work, have the same error message "`RightParen token excepted"` but i don't see what should i do here (or even if its the right function to do what i except)

Basically i want to obtain the sum of the `quantité livrée`, `quantité retournée`, `quantité facturée` by distinct `BL 2`
Any idea?

[Watsky · Accepted solution]

Hey @Anonymous ,

Looks like you're missing the right parenthesis at the end of the function.

= Table.Group(#"Changed Type", {"BL 2"},{{"quantité livrée", each List.Sum([#"quantité livrée"]), type number}})