• If a row contains a missing or null value, it is not factored into the calculation. If the entire column contains no values, the function returns a null value.
• If there is a tie in which the most occurrences of a value is shared between values, then no value is returned from the function.
• When used in a pivot transform, the function is computed for each instance of the value specified in the group parameter. See Pivot Transform.

...