set analysis at the turn of the year

[Anonymous]

Hi,

how can I deal with this formula?

I think that I have to change to optimize the previous week formular, because it will not work in 2016.

current week:

=COUNT({$<Year={$(=Year(MAX(Date)))},Week={$(=Week(MAX(Date)))}>}ID)
previous week:
COUNT({$<Year={$(=Year(MAX(Date)))},Week={$(=Week(MAX(Date))-1)}>}ID)

Thanks.

[sunny_talwar]

I would recommend using Date or WeekYear field created in the script to do a set analysis instead of using Year and Week fields separately.