
Re: Need Rank on Sum of Ranks
Sunny Talwar Nov 7, 2017 1:17 PM (in response to Dan Coen)May be try without dollar sign expansion
Aggr(
Rank(
Sum_of_Rank,
4,1),
Rep)

Re: Need Rank on Sum of Ranks
Dan Coen Nov 7, 2017 1:22 PM (in response to Sunny Talwar )Hi Sunny, thats not working, I added the formula in the variable directly to the expression and it still does not work. See below.
Aggr(
Rank(
Column(6) + Column(7) + Column(8) + Column(9),
4,1),
[Rep])

Re: Need Rank on Sum of Ranks
Sunny Talwar Nov 7, 2017 1:29 PM (in response to Dan Coen)Well, you cannot really use Column reference within the Aggr() function... you need to use the exact expressions

Re: Need Rank on Sum of Ranks
Dan Coen Nov 7, 2017 1:36 PM (in response to Sunny Talwar )Ok, thanks. thats the problem. In place I pasted in all the expression from the 4 columns and that worked. Thanks so much Sunny!

Re: Need Rank on Sum of Ranks
Dan Coen Nov 7, 2017 3:05 PM (in response to Sunny Talwar )Sunny,
I added all the expressions togther from those columns like you suggested and it seems to be working. However, I actually want to do the reverse ranking. For example:
the numbers for 4 ranking columns are 4+4+5+13 which equals a sum of rankings of 26, which is the lowest sum of all the corresponding ranking columns, and therefore has the best Power Ranking.
on the flip side: 127+130+132+104=493 has highest sum of all the corresponding ranking columns, and therefore has the worst Power Ranking.
However, this PowerRankning expresion below is ranking based on the hihest number, so therefore 493 is the 1 ranking while 26 is 135. I want to flip this around.
Aggr(
Rank(
Aggr(Rank($(vGSPRanking_Current_FY_QTD_Sales),),[Rep])
+
Aggr(Rank($(vGSPRanking_Current_FY_QTD_Sales)$(vGSPRanking_Prior_YQTD),4,1),[Rep])
+
Aggr(Rank(($(vGSPRanking_Current_FY_QTD_Sales)$(vGSPRanking_Prior_YQTD))/$(vGSPRanking_Prior_YQTD),4),[Rep])
+
Aggr(Rank(sum([Shipped])/Sum([Quota])*$(=$(vExp_Pct_CurrQtr_TD)),4),[Rep]),
4,1,),
[ Rep])
Any ideas?

Re: Need Rank on Sum of Ranks
Sunny Talwar Nov 7, 2017 3:32 PM (in response to Dan Coen)May be add minus sign in front of all your expressions or multiple the sum by 1

Re: Need Rank on Sum of Ranks
Dan Coen Nov 8, 2017 8:21 AM (in response to Sunny Talwar )That worked! thanks!





