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.