| Display Rounding Mode |
Specifies the rounding mode for displaying numeric data values in reports and dashboards that are created on this data source.
Data Type: Enumeration
The following are details about each rounding mode. For more information, refer to http://docs.oracle.com/javase/7/docs/api/java/math/RoundingMode.html.
- Up
Rounding mode to round away from zero. Always increments the digit prior to a non-zero discarded fraction.
Example:
| Input Number |
Input rounded to one digit
with Up rounding |
| 5.5 |
6 |
| 2.5 |
3 |
| 1.6 |
2 |
| 1.1 |
2 |
| 1.0 |
1 |
| -1.0 |
-1 |
| -1.1 |
-2 |
| -1.6 |
-2 |
| -2.5 |
-3 |
| -5.5 |
-6 |
- Down
Rounding mode to round towards zero. Never increments the digit prior to a discarded fraction (that is, truncates).
Example:
| Input Number |
Input rounded to one digit
with Down rounding |
| 5.5 |
5 |
| 2.5 |
2 |
| 1.6 |
1 |
| 1.1 |
1 |
| 1.0 |
1 |
| -1.0 |
-1 |
| -1.1 |
-1 |
| -1.6 |
-1 |
| -2.5 |
-2 |
| -5.5 |
-5 |
- Ceiling
Rounding mode to round towards positive infinity. If the result is positive, behaves as for Up; if negative, behaves as for Down.
Example:
| Input Number |
Input rounded to one digit
with Ceiling rounding |
| 5.5 |
6 |
| 2.5 |
3 |
| 1.6 |
2 |
| 1.1 |
2 |
| 1.0 |
1 |
| -1.0 |
-1 |
| -1.1 |
-1 |
| -1.6 |
-1 |
| -2.5 |
-2 |
| -5.5 |
-5 |
- Floor
Rounding mode to round towards negative infinity. If the result is positive, behaves as for Down; if negative, behaves as for Up.
Example:
| Input Number |
Input rounded to one digit
with Floor rounding |
| 5.5 |
5 |
| 2.5 |
2 |
| 1.6 |
1 |
| 1.1 |
1 |
| 1.0 |
1 |
| -1.0 |
-1 |
| -1.1 |
-2 |
| -1.6 |
-2 |
| -2.5 |
-3 |
| -5.5 |
-6 |
- Half up
Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round up. Behaves as for Up if the discarded fraction is >= 0.5; otherwise, behaves as for Down.
Example:
| Input Number |
Input rounded to one digit
with Half up rounding |
| 5.5 |
6 |
| 2.5 |
3 |
| 1.6 |
2 |
| 1.1 |
1 |
| 1.0 |
1 |
| -1.0 |
-1 |
| -1.1 |
-1 |
| -1.6 |
-2 |
| -2.5 |
-3 |
| -5.5 |
-6 |
- Half down
Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round down. Behaves as for Up if the discarded fraction is > 0.5; otherwise, behaves as for Down.
Example:
| Input Number |
Input rounded to one digit
with Half down rounding |
| 5.5 |
5 |
| 2.5 |
2 |
| 1.6 |
2 |
| 1.1 |
1 |
| 1.0 |
1 |
| -1.0 |
-1 |
| -1.1 |
-1 |
| -1.6 |
-2 |
| -2.5 |
-2 |
| -5.5 |
-5 |
- Half even
Rounding mode to round towards the "nearest neighbor" unless both neighbors are equidistant, in which case, round towards the even neighbor. Behaves as for Half up if the digit to the left of the discarded fraction is odd; behaves as for Half down if it's even.
Example:
| Input Number |
Input rounded to one digit
with Half even rounding |
| 5.5 |
6 |
| 2.5 |
2 |
| 1.6 |
2 |
| 1.1 |
1 |
| 1.0 |
1 |
| -1.0 |
-1 |
| -1.1 |
-1 |
| -1.6 |
-2 |
| -2.5 |
-2 |
| -5.5 |
-6 |
|
