Pulling latest date from list of records for attendance

[DavidRyan]

I have a Table(a) that lists skaters and another table(b) that lists all attendance records. I wanted to pull the latest date of attendance for each skater in to table(a). I have the found the below expression works in the test but fails to show up when going to view data. Does anyone have any thoughts?

LOOKUP(MAX([Related Attendance Records][_ROWNUMBER]),"Attendance Record","_ROWNUMBER","Date")

[Joseph_Seddik · Accepted solution]

MAX([Related Attendance Records][Date])