IBM Cognos User Manual

Syntax
absolute (numeric_exp)
Examples
absolute (-5.3)
Returns the result: 5.3
absolute (2)
Returns the result: 2
Ceiling
Returns a number rounded to the next highest integer.
Syntax
ceiling (numeric_exp)
Examples
ceiling (-1.23)
Returns the result: -1
ceiling (1.23)
Returns the result: 2
Floor
Returns a number rounded to the next lowest integer.
Syntax
floor (numeric_exp)
Examples
floor (-1.23)
Returns the result: -2
floor (3.45)
Returns the result: 3
Integer-Divide
Returns the integer obtained from truncating the result of an integer divided by a
second integer.
Syntax
integer-divide (integer_exp1, integer_exp2)
Examples
integer-divide (10, 20)
Returns the result: 0
integer-divide (20, 6)
Returns the result: 3
Appendix F. IBM Cognos Transformer Expression Editor 363

IBM Cognos Specifications

General

Developer	IBM
Data Source	flat files
Operating System	Microsoft Windows
License	Commercial
Input Sources	SQL databases, Excel, CSV
Platform	Microsoft Windows