Sum with multiple criteria on the same field

[theboss-123]

Hello i want to calculate sum of "Quantité" where ID_Transaction are 1 and 3 i set the below formula but it is not working

u used the formula : 

=sum({$ < [ID_Transaction] = {"1"},[ID_Transaction] ={"3"} >}[Qantité] )

when i select Item " DIS001" and the date 03/01/2016 it return just

it calculated just sum Quantité of ID 3

[Vegar]

I think this will help you get what you want.

=sum({$ < [ID_Transaction] = {"1", "3"} >}[Qantité] )

[theboss-123 · Accepted solution]

Thanks it solved using the formula

=sum({$ < [ID_Transaction] = {"1","3"} >}[Qantité] )