If Syntax

[Anonymous]

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!

[alexandros17]

wildmatch([Event], $(myWeek))

where myWeek is a variable

Hope it helps

[Anonymous]

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

[alexandros17]

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)

[MarcoWedel]

Sum({$ <Event={"*Flyer*"}, week={'>=max([PO Rec Date])<=max([PO Rec Date]+6'}>} myValue)