Set Analysis

[bimanbeginner]

Hi

Set Analysis doesn't seem  to work  when summing a variable.

I have hard coded the FIN_YR_MTH_NO and it does not seem to work, any suggestions would be appreciated.

=Avg({<FIN_YR_NO={$(vMaxFinYr)},FIN_YR_MTH_NO={201705},MTH_SHORT_DESC=>}  $(vCALC))

Regards,

[tresesco · Accepted solution]

May be this?

= Avg( {<YRMTHNO={"<=$(=(vMaxYearNo))"}>} Aggr(

((Sum({<YRMTHNO={"<=$(=(vMaxYearNo))"}>}GreatScore1)/  (Sum({<YRMTHNO={"<=$(=(vMaxYearNo))"}>}GreatScore1) + Sum({<YRMTHNO={"<=$(=(vMaxYearNo))"}>}AverageScore1) + Sum({<YRMTHNO={"<=$(=(vMaxYearNo))"}>}PoorScore1) ))*0.7)

+

((Sum({<YRMTHNO={"<=$(=(vMaxYearNo))"}>}GreatScore2)/  (Sum({<YRMTHNO={"<=$(=(vMaxYearNo))"}>}GreatScore2) + Sum({<YRMTHNO={"<=$(=(vMaxYearNo))"}>}AverageScore2) + Sum({<YRMTHNO={"<=$(=(vMaxYearNo))"}>}PoorScore2) ))*0.3)

,YRMTHNO))

[bimanbeginner]

Thank you so much, Exactly what I needed!!!