Dynamic Expression Label

[Anonymous]

Hi,

     In my expression label I am trying to create a field name that reflects the specific week number indicated in the expression. My expression is as follows:

SUM({$<Year={$(=Max(Year))},

  Period=,

  Week=,

  [Year Period]=,

  [Year Week]=,

  Date={">=$(=date(date(vCurrentWeekStart)-91))<=$(=date(date(vCurrentWeekStart)-85))"},

  SKU=P(SKU)>} [POS Net Units])

How do I make an expression label that reflects which week the dates specify? I have tried

=Week(  Date={">=$(=date(date(vCurrentWeekStart)-91))<=$(=date(date(vCurrentWeekStart)-85))"}) but I haven't had any luck.

Any help would be great!

[Anonymous · Accepted solution]

Trying to understand the logic...  Look like this will be the label:

week(vCurrentWeekStart-91)

[Anonymous]

Figured it out! Thanks!