SMALL

The SMALL function returns the Nth smallest value in a dataset.

Supported Product Scenarios

The SMALL function is supported in the following YiDA scenarios:

SMALL(Array,number)

Attribute	Required	Description
Array	Yes	Array-type data. You can directly reference a Numerical component in a subform.
number	Yes	Number type. Specifies the rank of the smallest value to retrieve.

Return type	Description
Numerical	The retrieved value.

As shown below, use the SMALL() and ADD() functions to calculate the score of the student ranked second from last in the class.

Return the 3rd smallest value across multiple rows of subform data.