Forum Discussion
Solved
RANKX with groups
Need some regarding the Rankx function. I need to assign ranks to the candidates on their average scores grouped by their group_Name. I tried the following and recieveing an error: Rank = rankx(a...
Sorry! My bad! Its working the way it should..the problem was fixed by fixing the decimal points of average grades to 2 digits..Thank you so much again!
Sorry! My bad! Its working the way it should..the problem was fixed by fixing the decimal points of average grades to 2 digits..Thank you so much again!
I'm sorry for necroing this thread but when I try the proposed solution I get the error "EARLIER/EARLIEST refers to an earlier row contect which doesn't exist."
What creates the previous row context in your case but not mine? I have a plain table I try to rank by a grouping just the same way as in the example.