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.


LAST([list_of_values])-> last_item


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.

Return Value

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