Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum( {< [Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'}, SeasonCalc = {"$(vCurrentSeasonCalc)"}, [Year Week]= {"$(='>=' & vYearWeek_YD)"} >} Order_Budget_Qty)
There's no error in the expression, however, the table comes out blank
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].
Try
Sum(
{<
[Store Type2]={'concept','Estore','HQ Ret','SiS','Soft shop'},
SeasonCalc = {"$(=vCurrentSeasonCalc)"} ,
[Year Week]={">=$(=vYearWeek_YD)"}
>}
Order_Budget_Qty)