Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 685
If
Description Evaluates a condition and returns a value based on that condition.
Syntax If ( boolean, truevalue, falsevalue )
Return value
The datatype of truevalue or falsevalue. Returns truevalue if boolean is true
and falsevalue if it is
false. Returns null if an error occurs.
Examples This expression returns Boss if salary is over $100,000 and Employee if salary
is less than or equal to $100,000:
If(salary > 100000, "Boss", "Employee")
This expression returns Boss if salary is over $100,000, Supervisor if salary is
between $12,000 and $100,000, and Clerk if salary is less than or equal to
$12,000:
If(salary > 100000, "Boss", If(salary > 12000,
"Supervisor", "Clerk"))
In this example of a validation rule, the value the user should enter in the
commission column depends on the price. If price is greater than or equal to
1000, then the commission is between .10 and .20. If price is less than 1000,
then the commission must be between .04 and .09. The validation rule is:
(Number(GetText()) >= If(price >=1000, .10, .04)) AND
(Number(GetText()) <= If(price >= 1000, .20, .09))
The accompanying error message expression might be:
"Price is " + If(price >= 1000, "greater than or
equal to", "less than") + " 1000. Commission must be
between " + If(price >= 1000, ".10", ".04") + " and "
+ If(price >= 1000, ".20.", ".09.")
See also
“Example 1: counting null values in a column” on page 630
“Example 2: counting male and female employees” on page 632
“Example 3: creating a row indicator” on page 636
“Example 4: displaying all data when a column allows nulls” on page 638
Case
Argument Description
boolean A boolean expression that evaluates to
true or false.
truevalue The value you want returned if the boolean expression is
true. The
value can be a string or numeric value.
falsevalue The value you want returned if the boolean expression is
false. The
value can be a string or numeric value.