Case Value

Returns values based on the evaluation result of a given expression. Evaluates a single metric against multiple conditions. This is a single-value function.

Syntax

CaseV(Argument1, Argument2, Argument3, Argument4..., ArgumentN)

•  

• Argument1 is the metric against which all values are compared.

• Argument2  is the first value, constant or metric, to compare with Argument1.

• Argument3 is the information to return, constant or metric, if the first comparison is true.

• Argument4 is the second value, constant or metric, to compare with Argument1.

• Argument5 is the information to return, constant or metric, if the second comparison is true.

• ArgumentN is the information to return, constant or metric, if none of the comparisons are true.

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