1 Reply Latest reply: Sep 8, 2012 8:15 AM by whiteline _ RSS

    10 week average

      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?