Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Trying to understand the logic... Look like this will be the label:
week(vCurrentWeekStart-91)
Trying to understand the logic... Look like this will be the label:
week(vCurrentWeekStart-91)
Figured it out! Thanks!