if condition on aggr

[canmarroig]

Hi, i need to calculate, sum(quantity) only for invoice >0  in a box

Invoice	quantity	USD
a	22	20,99
b	8	0
c	5	0
d	3	0
e	5	0
f	43	69
g	38	37,95
h	16	0
i	86	10,9
l	38	158,19

Thanks

[shraddha_g]

Do you mean invoice having USD>0?

[canmarroig]

Yess,

[shraddha_g · Accepted solution]

Try:

sum({<USD = {">0"}>}quantity)