Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
If I am trying to determine whether a SKU falls into an Event labeled by Flyer during a particular week, should I do this as an if statement or a set analysis?
I can determine whether or not the SKU is part of a flyer event with the following:
if([Event] like '*Flyer*','Yes')
However, how do I incorporate a particular week that is dynamic into that expression? I am specifically trying to find whether or not the SKU is part of a flyer event between max([PO Rec Date]) and max([PO Rec Date])+6
Thanks!
wildmatch([Event], $(myWeek))
where myWeek is a variable
Hope it helps
I think that might work!. How would I define the variable to include my range be
>=max([PO Rec Date])<=max([PO Rec Date]+6
You need a range not a single value:
at this point, if you need that condition in an expression, you can do something like:
Sum({$ <Event={'>=max([PO Rec Date])<=max([PO Rec Date]+6'}>} myValue)
Sum({$ <Event={"*Flyer*"}, week={'>=max([PO Rec Date])<=max([PO Rec Date]+6'}>} myValue)