Function First() and Last()

Tips and Tricks

Returns the first or last value in a set.

Usage:

First( r )

Last( r )

Parameters:

r

This is a reference to a question in a repeating page, repeating section or multiple row data source

Example:

The example below returns the most recent item bought from a store.

Last([Q1.BoughtItems])
 

Related Articles

Keywords

Formula Design Format Function First Last