I am trying to get a latest score for candidates that have retaken a class exam. a candidate can take same exam several times. My requirement is to always return the last exam score they took. I have tried to use the LAST function on the rpd but when i use it,i get blank rows. Is there a simpler way of capturing the latest candidate exam score? on the rpd or even analysis?