Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently I have a rolling 12 months total using the following:
=NUM(AVG({$<CalendarYear =, CalendarMonthName =,AddedOn={">=$(=addmonths(max(AddedOn),-12)) <=$(=max(AddedOn))"}>} MonthlyTargetValue),'##')
I'd like to get the rolling twelve months from the previous month not the current month.
it depends on how you date
=NUM(AVG({$<CalendarYear =, CalendarMonthName =,AddedOn={">=$(=addmonths(max(AddedOn),-12)) <=$(=monthend(max(AddedOn),-1))"}>} MonthlyTargetValue),'##')
it depends on how you date
=NUM(AVG({$<CalendarYear =, CalendarMonthName =,AddedOn={">=$(=addmonths(max(AddedOn),-12)) <=$(=monthend(max(AddedOn),-1))"}>} MonthlyTargetValue),'##')
monthend did it, thank you