Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 649
This expression for the Background.Color property of an employee Id column
returns red for Id 101, gray for Id 102, and black for all other Id numbers:
Case(emp_id WHEN 101 THEN 255 WHEN 102 THEN
RGB(100,100,100) ELSE 0)
This expression for the Format property of the Marital_status column returns
Single, Married, and Unknown based on the data value of the Marital_status
column for an employee:
Case(marital_status WHEN 'S'THEN 'Single' WHEN 'M' THEN
'Married' ELSE 'Unknown')
See also “Example 3: creating a row indicator” on page 636
If
Ceiling
Description Retrieves the smallest whole number that is greater than or equal to a specified
limit.
Syntax Ceiling ( n )
Return value The datatype of n. Returns the smallest whole number that is greater than or
equal to n.
Examples These expressions both return -4:
Ceiling(-4.2)
Ceiling(-4.8)
This expression for a computed field returns ERROR if the value in
discount_amt is greater than the smallest whole number that is greater than or
equal to discount_factor times price. Otherwise, it returns discount_amt:
If(discount_amt <= Ceiling(discount_factor * price),
String(discount_amt), "ERROR")
Argument Description
n The number for which you want the smallest whole number that is
greater than or equal to it