Description

The LAST() function returns the last value of a specified field within a range or partition. This is useful for identifying the final entry.

Syntax

LAST(text)

Output

Varies based on input field type

ID

Group

Value

LAST

1

A

10

15

2

A

20

15

3

A

15

NULL

4

B

30

40

5

B

40

NULL