NumWeek 1 newyear vs NumWeek 52 prevyear - how to compare?

[tincholiver]

Hi, I make a request:
answering some cases about comparisons between weeks I was a doubt.
the expression that seemed useful to me to make that kind of comparison was:
sum ({<NumWeek = {'> = $ (= max (NumWeek) -1) <$ (= max (NumWeek))'}>} Sales) for the previous week and,
sum ({<NumWeek = {'> = $ (= max (NumWeek))'}>} Sales) for the current week.
The question is how to solve the cases in which the year changes being compared to week 1 of the new year, with the 52 of the previous year.

[Vegar · Accepted solution]

I would add a week index to my calendar. The first week in the calendar is 1 when you start the next year you let the index be 53 (not 1)

With this week index field you may apply your current set expression logic.

You will of course keep your old week number (1-52) for presentation purposes.

[tincholiver]

I understand, there seems to be no other method to solve this.
Thanks for your answer Vegar.