topic Re: Expression to only sum if in current year in Management & Governance

Expression to only sum if in current year

anthony-gb — Sat, 16 Nov 2024 00:27:30 GMT

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

Re: Expression to only sum if in current year

Or — Thu, 11 Mar 2021 13:49:02 GMT

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)

Re: Expression to only sum if in current year

anthony-gb — Fri, 12 Mar 2021 15:06:38 GMT

ugh, of course! thanks