Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Do you mean invoice having USD>0?
Yess,
Try:
sum({<USD = {">0"}>}quantity)