Case

Returns a value based on the conditional expression that is true. Evaluates multiple expressions and returns a specified value when a condition passes. If no condition passes a default value is returned. This is a single-value function.

Syntax

Case(Argument1, Argument2, Argument3,Argument 4...,ArgumentN)

•  

• Argument1 is the first condition to evaluate. The condition can contain metrics, comparison and logical operators, and constants.

• Argument2 is the information, a constant or metric value, to return if Argument1 condition is true.

• Argument3 is the second condition to evaluate. The condition can contain metrics, comparison and logical operators, and constants.

• Argument4 is the information, a constant or metric value, to return if the second condition is true.

• ArgumentN is the information to return if none of the other conditions are true.

For additional information on this function, refer to the MicroStrategy Functions Reference.