ROUNDDOWN function
This topic describes the formula syntax and usage of the ROUNDDOWN function in the Data Quality Execute Formula transform.
Description
Rounds a number down, toward zero. ROUNDDOWN behaves like ROUND, except that it always rounds a number down.
Syntax
ROUNDDOWN(number, number_digits)The ROUNDDOWN function syntax has the following arguments:
- number Required. A real number to round down.
- 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 down to the specified number of decimal places.
- If number_digits is 0, then number is rounded down to the nearest integer.
- If number_digits is less than 0, then number is rounded down to the left of the decimal point.
Examples
The following examples show various results for values in the Number field.
| Formula | Description | Result |
|---|---|---|
ROUNDDOWN([Number], 0) |
Rounds 4.3 to zero places. | 4 |
ROUNDDOWN([Number], 0) |
Rounds 77.9 down to zero decimal places. | 77 |
ROUNDDOWN([Number], 2) |
Rounds 2.71828 down to two decimal places. | 2.71 |
ROUNDDOWN([Number], 2) |
Rounds -2.71828 down to one decimal place. | -2.7 |
ROUNDDOWN([Number], 1) |
Rounds 2.71828 down to one decimal place. | 2.7 |
ROUNDDOWN([Number], -2) |
Rounds 6391.9320 down to 2 decimal places to the left of the decimal point | 6300 |