IF

Checks whether a condition is true or false and returns the value specified in the true argument if the condition is met or in the false argument if it is not. Multiple If statements may be nested to allow evaluation of more complex conditions.

IF ( condition, true, false)

  • Condition: The condition to be evaluated.

  • True: The value to return if the condition is true.

  • False: The value to return if the condition is false.

Example: create a field on the CUSTOMER table that uses an appropriate label to flag those records where annual income has not been supplied, otherwise returning the supplied annual income value.

IF( [CUSTOMER.INCOME] = 0, "NOT SUPPLIED",CUSTOMER.INCOME)