Rank Function
The Rank function calculates the rank for each value in a set of input values.
1. Syntax
RANK(d0,s0,s1,s2,Alignment)
2. Input
The Rank function requires the following input:
- d0 - The set of data values for which the rank is calculated.
3. Parameters
The Rank function requires the following parameters.
- s0 - Indicates which way the values should be sorted for ranking. 0 for descending, 1 for ascending. The default value is 0.
- s1 - Indicates how ties should be handled. The default value is 0.
0 - Order of occurrence breaks tie
1 - Podium
2 - Lowest possible
3 - Highest possible
- s2 - If greater than 0, ranks will be scaled so that the highest rank is the value. The default value is 0.
- Alignment (optional) - Hierarchy placeholder to be used as the alignment axis.
4. Output
The Rank function generates the following output:
- Rank - The Rank result set, consisting of rank values corresponding with each input value.