Forum Discussion

ontario234's avatar
ontario234
Helper I
8 years ago
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...
Need Help
  • ontario234's avatar
    ontario234
    8 years ago

    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!

ontario234's avatar
ontario234
Helper I
8 years ago

Thank you Zubair. It worked however, i need to assign same rank when the average scores are same. For example; if there are two canidates with a score of 4.15, both of them should be assigned same rank instead of 2 consecutive ranks. Any suggestions on how to achieve that? Thanks

ontario234's avatar
ontario234
Helper I
8 years ago

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!

  • Molotch's avatar
    Molotch
    Helper II
    8 years ago

    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.