ROUNDUP function
This topic describes the formula syntax and usage of the ROUNDUP function in the Data Quality Execute Formula transform.
Description
Rounds a number up, away from zero. ROUNDUP behaves like ROUND, except that it always rounds a number up.
Syntax
ROUNDUP(number, number_digits)The ROUNDUP function syntax has the following arguments:
- number Required. A real number to round up.
- number_digits Required. The number of digits to which to round the number.
Notes
- If number_digits is greater than 0 (zero), then number is rounded up to the specified number of decimal places.
- If number_digits is 0, then number is rounded up to the nearest integer.
- If number_digits is less than 0, then number is rounded up to the left of the decimal point.
Examples
The following examples show various results for values in the Number field.
| Formula | Description | Result |
|---|---|---|
ROUNDUP([Number], 0) |
Rounds 4.3 to zero places. | 5 |
ROUNDUP([Number], 0) |
Rounds 77.9 up to zero decimal places. | 78 |
ROUNDUP([Number], 2) |
Rounds 2.71828 up to two decimal places. | 2.72 |
ROUNDUP([Number], 2) |
Rounds -2.71828 up to one decimal place. | -2.8 |
ROUNDUP([Number], 1) |
Rounds 2.71828 up to one decimal place. | 2.8 |
ROUNDUP([Number], -2) |
Rounds 6391.9320 up to 2 decimal places to the left of the decimal point | 6400 |