KB8810: How to display a "0" instead of a negative metric value in a report without using thresholds or apply functions in MicroStrategy Developer

Observe in the following screenshot that the cost for Atlanta is a negative value: "-123".

The following procedure describes how to display this negative metric value with "0":
 

• Open the metric in the metric editor.
• Go to Tools > Formatting > Values.
• In the Format Cells window, select the Number tab.
• Click on Custom in the Category section and select (#,##0; "0") from the Custom drop down box, as shown in the screen shot below:
  

• Click 'OK' and save and close the metric editor.

Re-execute the report. The negative data will now be displayed as "0", as shown in the screen shot below: