#Groupvar does not appear to be working. For instance in this screen:
SetVar(@Group,FRank(“Inst%Own”)>89.99)
SetVar(@Dec1AvgRet,Eval(Frank(“Inst%Own”)>89.99,Aggregate(“Pr13W%Chg”, #GroupVar, #Avg,0),0))//Test to set the average return for the decile
ShowVar(@Dec1AvgRet,Eval(Frank(“Inst%Own”)>89.99,Aggregate(“Pr13W%Chg”, #GroupVar, #Avg,0),0))
The Pr13W%Chg number returned is for the entire universe, not the subset requested.
I have confirmed that @Group does return 1 for pass and 0 for not pass.
If I modify the screen to this I can get my numbers by using #previous. However my full screen is designed to pull average returns for each decile in the factor.
FRank(“Inst%Own”)>89.99)
ShowVar(@Dec1AvgRet,Eval(Frank(“Inst%Own”)>89.99,Aggregate(“Pr13W%Chg”, #Previous, #Avg,0),0))//Test to set the average return for the decile
Would be grateful if you could have a look and see that #Groupvar is operating.