Share via

Iif (PEL)

  • Article

This function evaluates two expressions against a specified logical test.

Iif(
      Logical_Expression,
      True_Expression,
      False_Expression
      )

Parameters

  • Logical_Expression
    A valid PerformancePoint Expression Language (PEL) logical expression that evaluates to true or false.
  • True_Expression
    A valid PEL expression. Must be of type Number or type String, and must match the type of False_Expression.
  • False_Expression
    A valid PEL expression. Must be of type Number or type String, and must match the type of True_Expression.

Return Value

If Logical_Expression evaluates to true, the Iiffunction returns True_Expression. Otherwise, the function returns False_Expression.

If either expression evaluates to NULL, the result set will be NULL when that condition is met.

Remarks

True_Expression and******False_Expression must match in type. The type must be Number or String.

We do not recommend the Iif function for creating a set of members based on search criteria. Instead, use the Filter (PEL) function to evaluate each member in a specified set against a logical expression and return a subset of members.

The PEL compiler cannot generate SQL code for this function.

See Also

Reference

Filter (PEL)
SQL generation for PEL functions

Other Resources

PEL reference