SUM with conditions

[JuRoss]

Hi, i want to calculate the SUM of #ANZ in wich the year of my date is bigger or equal to Today().

Can you help me with the Syntax?

This is my Try:

=sum({<(year(Today())-2) >= year(date)>} [#ANZ])

[MeehyeOh · Accepted solution]

Hi @JuRoss 

Try this,

= Sum( {< date= {"=Year(date) >= Year(Today()-2)"}>} [#ANZ])

I think only values equal to or greater than today's year will be selected among the values in the [date] field.

cheer!