Hi guys
I'm using the following two formulas in 5 of my expressions to return the top 5 values.
This formula returns the value.
=num(max(aggr(sum({<YM={$(vRM)},
Process={'$(vCP)'}>}
AC_R.H),
R_Cy)),'###,###,###')
This formula returns the wording that should correspond with the value above.
=only(if(aggr(rank(max({<YM={$(vRM)},
Process={'$(vCP)'}>}
AC_R.H)),
R_Cy)=1,
R_Cy))
i have the following results
Values
85
8
2
1
Wording to go with values (ranked 1 to 5)
IR
BS
-
-
I should be getting
IR
BS
DP
LA
Where am i going wrong?
