set analysis sum field > 0

[chematos]

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

[swuehl]

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).

[suepenick]

use an if

sum(if(Amount>0, Amount))