Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
I'm not sure, maybe something like this?
sum(if([Year Week]>=
weekyear(today()-(7 * $(OrderVeckor)))&num(week(today()-(7 * $(OrderVeckor))),00)
,[Order Quantity],0))
Where are you calculate this value, script or expression?
If you could attach the qvw, it is better