The Last()
function returns the last item in a list or concept set.
For (persistent) lists it must indicate a field of that list.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns the last item in the given list
or concept_set
.
Returns Unknown
if one of the parameter values is unknown or outside the common valid date boundaries.
Possible fault message in expression editor: Invalid call to a function: parameter mismatch at position(x,y): Last
This could mean that there is no field of list used, but only the (reference to a) list.
The Last function needs a field from list where filter construction, or if you only want to get the last row of a list, use RowId([list]) of [list] where [filter]
.
Name | Type | Required | Description |
---|---|---|---|
values
list or a concept_set
a collection of values or elements of the same type, or a list of fields from a (persistent) list.