KB5390: How to convert Database Nulls to '0' so they can be sorted in MicroStrategy Developer 9.x-10.x

The following report is sorted on the Unit Sales metric ascending:

 
If the sorting is changed to descending, the report is as follows:

 
The Database Null value is still displayed on top.
 
To convert this Database Null to '0' for sorting to take effect, users must execute the following steps:

1. Edit the metric that has the Database Nulls. For this example, Unit Sales.
2. Change the Object Browser Location to: Functions and Operators Functions\Null/Zero Functions and add the NulltoZero Function to the metric definition.

 
The report now looks like the following:
 
Sorted descending:

 
Sorted ascending: