Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference ROUND
Functions and Expressions Reference Guide
173
Uses
Use
RIGHT when you need a specific part of a text item. For example, a
customer number may have several uses and sometimes only the last three
characters are needed.
RIGHT can be used to return only the rightmost three
characters.
Related Functions
FIND, LEFT, MID
ROUND
The ROUND function rounds a number to a specified number of decimal places. If
the number of decimal places is not specified, the number is rounded to a whole
number. The result is in character number format.
Syntax
ROUND (single-number-expression [ , single-integer-expression
])
Meaning
ROUND (number_to_round [ , number_of_decimal_places ])
Returns
This function returns a single-number.
ROUND converts number_to_round to character format, if necessary, and then
produces the value of number_to_round rounded to the number of decimal
places specified by number_of_decimal_places. If number_of_decimal_places
is not specified, number_to_round is rounded to the nearest whole number.
Examples
ROUND (1.46 , 1) returns 1.5
ROUND (1.46) returns 1