Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need help writing an expression out of the logic below.
=SUM(Jan-Y,current year)FieldName
where Y = any Month selected
current Year = Year selected
Check with this
Sum({<Month=,Year=,DateField={">=$(=YearStart(Max(DateField)))<=$(=MonthEnd(Max(DateField)))"}>} FieldName)