Expression to only sum if in current year

[anthony-gb]

I am trying to implement an expression to limit the amount only where the due_date is in the current year. I also only want to sum amounts > 0

I have tried many variations of this eg.

if(year(due_date) = year(today()) and amount > 0, sum(amount))

any help would be appreciated

[Or · Accepted solution]

You've got the right syntax, just the wrong way around. Your conditions go inside the sum rather than vice versa, since you  need them re-evaluated for each row.

Sum(If(Year(due_date)=year(Today()) AND amount>0,amount)

[anthony-gb]

ugh, of course! thanks