SMALL

The SMALL function returns the nth largest number from a list of values.

Syntax

small(index, list)

Arguments

index - The index specifies which largest value to return—for example, 1 returns the largest, 2 returns the second-largest, and so on.

list - The list of numbers to iterate through

Example

Use the SMALL function to return the second-highest value among the 2024 and 2023 metrics.

SMALL([[2024 Actuals], [2023 Actuals], [2023 Plan]],2)

Use the SMALL function to calculate the second largest value among the actual and plan measures