Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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))
Thank you so much, Exactly what I needed!!!