You are viewing content for 5.1 | 5.0 | 4.9 | 4.8 | 4.7 | 4.6 | 4.5 | 4.4 | 4.3 | Previous Releases


Returns one of two values depending how a given boolean expression evaluates.


Return “Great” if the country in COUNTRYNAME_ is “Spain” and “Other_Country” otherwise.

if(SALES.COUNTRIES.COUNTRY_NAME = "Spain", "Great", "Other_Country")


if (bool expr, expr1, expr2)
  • expr : bool expression
  • expr1 : expression to evaluate if expr evaluates to true
  • expr2 : expression to evaluate if expr evaluates to false


    <type> depending on what expr1 or expr2 evaluate to


Function if returns the expr1 if the boolean expression evaluates to true, otherwise it returns expr2. If the first and second expressions are numbers, the result will be of type double.

© Incorta, Inc. All Rights Reserved.