Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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!
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!