The SMALL function returns the nth smallest number from a list of values by identifying the value at the specified rank when the numbers are arranged from lowest to highest. It is useful for finding bottom or ranked values within a dataset.
SMALL(list, index)list: The list of numbers to evaluate.index: The position of the value to return when the numbers are sorted in ascending order. For example, 1 returns the smallest value, 2 returns the second-smallest value, and so on.Returns the nth smallest value from the specified list.
SMALL([2025.Q1.Actuals, 2025.Q2.Actuals, 2025.Q3.Actuals, 2025.Q4.Actuals], 1)In this example, the Least Actuals measure is created using the SMALL function, which returns the smallest value from the quarterly Actuals values of 2025.
