Median

Returns the value in the middle of a set of listed values, meaning that half of the entries in the list are greater than the median, half are less. This is a group-value function.

Syntax

Median<FactID>(Argument}

• FactID is a parameter that forces a calculation to take place on a specific fact table containing the FactID.

• Argument is an attribute, fact, or metric representing a list of numbers.

For additional information on and an example of this function, refer to the Functions Reference.