Set Analysis not working????

[#1]

Hi All

I have a point in time set analysis that should be returning the value for latest period - 11:

Avg({$<BasketFC.PeriodID = {"=$(=Max(BasketFC.PeriodID) - 11)"}>} BasketFC.BasketPercentage)

But for a reason I cannot fathom it's ignoring the Set completely?

But the following works:

=Avg({$<BasketFC.PeriodID = {1}>} BasketFC.BasketPercentage)

I've checked that =Max(BasketFC.PeriodID) - 11 does equal 1.....?

Please can anyone advise where I'm going wrong with this?

Thanks

Dominic

[sushil353]

hi,

Try this:

Avg({$<BasketFC.PeriodID = {"=$(=Maxstring(BasketFC.PeriodID) - 11)"}>} BasketFC.BasketPercentage)

HTH

Sushil

[#3]

Hi Sushil

That didn't make a difference?

Dom

[rajni_batra]

Try

Avg({$<BasketFC.PeriodID = {"$(=BasketFC.PeriodID)-11)"}>} BasketFC.BasketPercentage) 

[#5 · Accepted solution]

Figured it out! I needed to remove the quotes:

Avg({$<BasketFC.PeriodID = {$(=Max(BasketFC.PeriodID) - 11)}>} BasketFC.BasketPercentage)