Formatting negative values

Business owners need to see the sales figures by month and their month-on-month difference.

If the difference is negative (fall in sales) then it needs to be shown in red and values need to be in brackets.

Getting ready

Create a simple list report with Time / Year, Time / Month (numeric), and Sales fact / Quantity as columns.

Group Year and sort Month (numeric) in ascending order.

How to do it...

Showing negative values in red and between brackets is a familiar practice for analysts in tools like Excel. Here are the steps to create the exact same formatting in your reports:

  1. Add a new query calculation to the list. Define the expression as running-difference([Quantity]). Call this item as Running Difference.
  2. Open the Data Format ...

Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.