Reversing the sign of value in Management Report - Scale By feature

Requirement:

As a requirement, we need to reverse the sign of value available for any particular cell at Report level only. This can be achieved by out of box functionality of Scale By feature available in Management report or Reports.

As shown in below screenshot, consider the following grid where originally number for "Revenue from operations" is positive number. As per reporting requirement, we need to show this number with negative sign.

This can be performed by cell formatting within Report. Let's see how we can achieve it -

1. Go to that particular cell in grid. from property panel, select the Cell formatting as shown in below screenshot.

2. Under the "Formats", click on "Number". On "Number" window, go to "Scale Value by".

3. On "Scale value by" cell, mention -1.

4. Click Ok.

5. Save the report and run it.

As shown in below screenshot, sign for "Revenue from operations" has been reversed.

Created by Mohit Jain and Megha Gupta