10 week average

[#1]

Hi,

I need this year average and last year average.

This year average I get with this:

=(sum({<Date={'>=$(=WeekStart(Max(Date), -9))<=$(=Max(Date))'},Week=,Year=}Value))/10

But how can I change it that Date is the Date -1 year?

And what will happen if I select a date like 29 feb and it does not exist in the year before?

[whiteline]

=AddMonths(Date, -12)

Also you can use YearToDate() to check if the date is year to date.