2 Replies Latest reply: Sep 17, 2012 10:20 AM by Sandeep Hamelink RSS

    Previous week

    Sandeep Hamelink

      Can someone help me with this expression. I want to sum quantity. This quantity is summed for previous week. I can't seem to find the mistake.

       

       

      sum({$<Year = {$(=max(Year) - $(=if(max(Week) = 1, 1, 0)))}, Week = {$(=max(Week) + $(=if(max(Week) = 1, 51, 0)))}

      ,
      DateType={'Sales'}>} Quantity)

       

      Any help is welcome

       

      Gr. Sandeep