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 properties for this calculation from the Property list.
Set the Format type as Number and the Negative Sign Symbol as brackets () as shown in the following screenshot:
Now go to Condition Explorer and create a new condition variable of Boolean type...
