Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.