MicroStrategy ONE

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.