The LAST function returns the last value found in a given List.
This function takes only one parameter, which is of type List. Then each value in the List can be of a specific type. That is, if working with a List of type Text, values will be of type Text.
list_of_values (required, type: List)
A list containing a number of items. These items can be of any type and do not need to be the same type as each other.
last_item (type: varies according to the item type)
The last value of the List.
The following example searches for the last item in a List of type Text.
LAST(["Banana", "Apple", "Orange"]) -> Orange