Skip to content

Last

Description

Last returns the last value in the current window.

Syntax

Last(value)

Parameters

Parameter Required Type Description
value Yes Field or expression Expression whose last value is returned.

Notes

Window functions operate over the current ordered window or query context.

Example

Last(SalesAmount)

The expression returns the calculated result according to the current query context.