Set analysis not working

[neil-devlin]

Hi,

Wondering if anyone can help me with a set analysis issue. The below expression works if I make the week number = to 38 (our current week for reporting) or equal to a variable that also equals 38, however if I were to change the value to any other number the cell goes to null, despite their being a value for all 52 weeks. Curiously despite me using set analysis the expression is also influenced by selecting the week filter, so if choosing anything other than the current week (38) the cell will return a null value. Hopefully I've explained this issue well enough.

Expression:

Sum(Aggr(Sum ({$<Week={37},Year={$(vLFLCurrYr)},Date=,[Retailer Status]={'OPEN'},
IT_System_Week= > } DISTINCT [Budget Nett Sales]),[Week],[Retailer Code],[HRL Finance Group]))

[marcus_sommer · Accepted solution]

You may try to put your set analysis in the outer aggregation, too.

- Marcus

[neil-devlin]

Thanks for the reply, I'm not sure of the syntax for this? Sorry if thats a stupid question

[neil-devlin]

Apologies I've figured out the syntax and that indeed works, thanks for your help!