topic Re: Sum with multiple criteria on the same field in App Development

Sum with multiple criteria on the same field

theboss-123 — Tue, 17 May 2022 22:03:31 GMT

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 — Tue, 17 May 2022 22:07:45 GMT

I think this will help you get what you want.

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

theboss-123 — Tue, 17 May 2022 22:15:39 GMT

Thanks it solved using the formula

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