How to find (max less one) from a list of entries
To assess whether a team is progressing, my user needs to show the most recent score AND the score just before that one. The difference between the two will show direction of development.
Finding the score associated with max([date of score]@row) is reasonably straightforward.
Any ideas about how to find the score for the date that is not max, but max-1?
Row structure is roughly [Score Type] [Score] [Date of Evaluation] [Team member]
Over time there are several entries for each type of scoring for each team member.