I want to change this into a set analysis expression

[robinwiman]

Hi,

I had this:

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'} >} If(WildMatch(SeasonCalc, vCurrentSeasonCalc) and [Year Week]>= vYearWeek_YD, Order_Budget_Qty))

changed it into this:

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"} >} If([Year Week]>= vYearWeek_YD, Order_Budget_Qty))

Now trying to do this:

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {">=$(=vYearWeek_YD)"} >} Order_Budget_Qty)

But the last expression does not work. If I remove the >= it means that I will only get the current week, and I need the current week + all the future ones as well.

Any ideas? Thanks

[andrey_krylov]

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {"$(='>=' & vYearWeek_YD)"} >} Order_Budget_Qty)

[robinwiman]

There's no error in the expression, however, the table comes out blank

[andrey_krylov]

In fact, both expressions do not have syntax errors, this

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {">=$(=vYearWeek_YD)"} >} Order_Budget_Qty)

or this

Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {"$(='>=' & vYearWeek_YD)"} >} Order_Budget_Qty)

Can you attach a sample? Or check the values of  vYearWeek_YD and [Year Week].

[sasiparupudi1]

Try

Sum(

{<

[Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'},

SeasonCalc = {"$(=vCurrentSeasonCalc)"} ,

[Year Week]={">=$(=vYearWeek_YD)"}

>}

Order_Budget_Qty)