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 “-###,##”.
Result:
How Business Intelligence Works 