Try the Last() function:
field - any or , or an that returns a reference to a repeating or related field
If field specifies a repeating field then it returns the last non-blank repetition. If field specifies a related field, then it returns the last non-blank value in the related set.
Note The last related value will depend on the way are . If the related records are not sorted, then the Last function returns a value based on the creation order of the .
Last(ParcelBids) returns 1500 if ParcelBids is a number field defined to repeat with ten values and contains the values 2500, 1200, and 1500.
Last(Payments::PaymentDate) returns the payment date in the last matching record in the Payments table.
Last(if(IsEmpty(Company);PersonalPhone;WorkPhone)) returns the last non-empty phone number from the repeating field PersonalPhone when the Company field is empty. If the Company field is not empty, the function returns the last non-empty phone number from the repeating field WorkPhone.
Thanks so much. Works just like I would think. I used the search function in the calculation screen but only showed references to repeating fields. I should have looked beyond the built in help on that screen.