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:
- Add a new query calculation to the list. Define the expression as
running-difference([Quantity]). Call this item as Running Difference. - Open the Data Format ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
