field - any
repeating field or
related field, or an
expression that returns a reference to a repeating
field 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.
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.