IBM Support

How to truncate numeric values in a Cognos Report Studio report.

Technote (troubleshooting)


There may be circumstances where a numeric value needs to be truncated rather than rounded.
If formating is applied then rounding occurs.


Value does not match what is required.


Relational data source.

Resolving the problem

Set the Query Calculation Data Item expression as follows:

    cast(cast([calc]*100,integer), decimal(19,2))/100

The value of 100 will need to be adjusted based on the number of decimal places required.
The decimal(19.2) values may be adjusted as required.

Cross reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos Business Intelligence Report Studio AIX, HP-UX, HP Itanium, Linux, Solaris, Windows 8.3, 8.4, 8.4.1

Document information

More support for: Cognos Business Intelligence
Report Studio

Software version: 10.2, 10.2.1, 10.2.2

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: All Editions

Reference #: 1443585

Modified date: 31 March 2011

Translate this page: