Source Columns
For source columns, decimal data is rounded as it gets stored in the reporting database.
The PostgreSQL documentation describes the rounding process: (see the end of 8.1. Numeric Types section)
When rounding values, the numeric type rounds ties away from zero, while (on most machines) the real and double precision types round ties to the nearest even number. For example:
Note: If this is a Relational Source using custom SQL the customer can change the SQL to specify how they want the rounding to happen before it gets to MITS Report.
Calculated Columns
Calculated columns get rounded on the fly if they are not materialized, and stored in the Source if they are materialized, if they have enhanced capabilities enabled.
Calculated Column rounding uses java mode
RoundingMode.HALF_UP
:Rounding mode to round towards "nearest neighbor" unless both neighbors are equidistant, in which case round up. Behaves as for RoundingMode.UP if the discarded fraction is ≥ 0.5; otherwise, behaves as for RoundingMode.DOWN. Note that this is the rounding mode commonly taught at school. This mode corresponds to the IEEE 754-2019 rounding attribute roundTiesToAway.
Example:
Comments
0 comments
Please sign in to leave a comment.