I have a custom object that we use for test scores for our students(contacts). A student can take the same test multiple times. My goal is to create a custom field in the contacts object that shows the score of the first test a student takes based on a date-entry field in the same custom object. Below is an example:
Test A - Date: 1/5/2010 - Score: 60
Test B - Date: 2/15/2010 - Score: 50
Test C - Date: 3/25/2010 - Score: 70
Jane Doe - First Score: 60
I have tried creating a rollup summary that takes the MIN of the Date field, then create a Number field to access that field, but there doesn't seem to be a formula that loops through all entries for that student. Also tried creating another rollup summary and using the field criteria with the MIN Date rollup summary but with no luck.
Thanks for any help.