First

Description

First returns the first value in the current window.

Syntax

First(value)

Parameters

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

Notes

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

Example

First(SalesAmount)

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