MicroStrategy ONE
Least
This function returns the smaller of two or more values. The Least function differs from the Min function, which returns the smallest value in a single value list. Least can take multiple lists as input and compare the elements of the lists. It is used for comparisons between metrics. This is a single-value function.
Syntax
Least(Argument1, Argument2,..., ArgumentN)
Where:
The arguments must be metrics.
Example
This simple example illustrates how data is returned by the Least function.
Given two values lists, the function compares the values at each position in the lists and returns a list of the lowest values from each position.
| List 1 | List 2 | Result List |
|
21 |
50 |
21 |
|
18 |
3 |
3 |
|
42 |
22 |
22 |
|
30 |
6 |
6 |
|
7 |
20 |
7 |