1 Reply Latest reply: Dec 30, 2013 11:03 AM by Michele Barini RSS

    sales if statement based on variable

    Bradley Coyne

      hi i have the following statement

       

      sum(if([Year Week]=weekyear(today()-7)&num(week(today()-((7 * $(OrderVeckor))

      )),00),[Order Quantity],0))

       

       

      $(OrderVeckor) = 7

       

      201346 - 201401

       

      i wish to calculate the Orderquantity for the last 7 weeks.

       

      my statement however is wrongly formulated, any suggestions.

       

      Best

      Brad