Sign Flipping in Cognos Reports

In many instances, especially when Financial Reports are involved, there is need to change the sign at the report level than how it is stored in the Database.

This can be achieved quickly using pattern properties in Data Format.

For example: In the below report output, for the years 2005 and 2006 the natural sign is negative.Using pattern properties in the Data format we can change the sign from negative to positive and vice versa.


Step 1: Select the measure and click on data format.

For Negative Pattern, enter ” ###,##’. Make sure to enter space at the start.

For Pattern, enter “(###,##)” or “-###,##”.





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s