Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Figured it out! I needed to remove the quotes:
Avg({$<BasketFC.PeriodID = {$(=Max(BasketFC.PeriodID) - 11)}>} BasketFC.BasketPercentage)
hi,
Try this:
Avg({$<BasketFC.PeriodID = {"=$(=Maxstring(BasketFC.PeriodID) - 11)"}>} BasketFC.BasketPercentage)
HTH
Sushil
Hi Sushil
That didn't make a difference?
Dom
Try
Avg({$<BasketFC.PeriodID = {"$(=BasketFC.PeriodID)-11)"}>} BasketFC.BasketPercentage)
Figured it out! I needed to remove the quotes:
Avg({$<BasketFC.PeriodID = {$(=Max(BasketFC.PeriodID) - 11)}>} BasketFC.BasketPercentage)