KB32678: How to keep Null attribute values as blank and Null metric values as zero in grid report in MicroStrategy Developer 10.x

When a grid report contains Null attribute values and Null metric values, all Null values will display as blank by default as shown below:
 

 
Follow the steps below to display Null attribute values as blank and Null metric values as zero in a Strategy report:
 

1. Modify the expression of the fact (that is used in the report metric expression) to: NullToZero(Blankfield):

• In Report Data Options > Display > Null values display settings, leave all default settings:

• In the report, Null attribute values will display as blank and Null metric values as zero: