Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here are the variables:
I'd like to turn this statement into a set expression:
Sum ( If( [Year Week] = vYearWeekLY_YD and WeekDayNumber = vWeekDayNumberYD, Fsgexkl_Loc*Comparable_week))
But when I do it like:
Sum ( {$< [Year Week] ={'$(=$(vYearWeekLY_YD))'}, WeekDayNumber = {'$(=$(vWeekDayNumberYD))'} >} Fsgexkl_Loc*Comparable_week))
It does not work.
Where am I going wrong with this? It's always the same when dabbling with variables in set expressions - frustrating.
Thanks
Try this
Sum ( {$< [Year Week] ={"$(vYearWeekLY_YD)"}, WeekDayNumber = {'$(vWeekDayNumberYD)"} >} Fsgexkl_Loc*Comparable_week))
Do you have a sample app to support and show case your issue?
I looked in our script and here's how the variables are created:
LET VECKANR_YD = num(Week(today()-1),00); //Week number yesterday
LET vYearWeek_YD = Year(Today()-1)&'W'& $(VECKANR_YD); //year week yesterday
LET vYearWeekLY_YD = Year(AddMonths(Today()-1,-12))&'W'& $(VECKANR_YD); //year week last year yesterday
Try below :
Sum ( {$ < [Year Week] ={$(=vYearWeekLY_YD)}, WeekDayNumber = {$(=vWeekDayNumberYD)} > } Fsgexkl_Loc*Comparable_week )
Sum ( {$ < [Year Week] ={'$(vYearWeekLY_YD)'}, WeekDayNumber = {'$(vWeekDayNumberYD)'} > } Fsgexkl_Loc*Comparable_week )