IBM Cognos - Text Functions

Returns the result: -100
round-zero (366.2162, 0)
Returns the result: 366
round-zero (366.2162, 1)
Returns the result: 366.2
round-zero (366.2162, -1)
Returns the result: 360
round-zero (366.2162, -2)
Returns the result: 300
Sqrt
Returns the square root of a positive number.
Syntax
sqrt (numeric_exp)
Examples
sqrt (2)
Returns the result: 1.4142135623731
sqrt (64)
Returns the result: 8
Text Functions
Text functions accept character input and can return both character and numeric
values.
Function Description
Char_Length Returns the number of characters in a string.
First-Word Returns the first word in a string.
Left Returns a specific number of characters, starting at the left of the
string.
Lower Converts uppercase characters to lowercase.
Position Returns the starting position of a string in a second string.
Reverse Reverses the characters in a string.
Right Returns a specific number of characters, starting at the right of the
string.
String-to-Integer
Converts a string to an integer.
Substring Returns a substring from a string.
Appendix F. IBM Cognos Transformer Expression Editor 367