Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the next issue:
I need to sum a field (Amount), but only when the amount is positive and this expression is not working.
I know that the same expression with different fields, works, but with the same field... it seems to be a problem
sum({$<Amount={">=0"}>}Amount)
Thank you,
Regards
Chema
Well, yes. How we are supposed to help here?
This should work (as you said yourself, and I can't see a reason why this shouldn't work given the information you posted).
use an if
sum(if(Amount>0, Amount))