2 Replies Latest reply: Mar 26, 2014 2:58 PM by Isabel Nowinowski RSS

    Dynamic Expression Label

    Isabel Nowinowski

      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!