Display Zeros for Null fields in a Report

[MicrostrategySol]

Nlim,

I have Report in which the metrics have transformations and the metrics are returning Null data as there is no data in the database .

Now my problem is i want to display null fields as Zero's . I have tried Configuring the Project in the Advanced Tab by setting the Null Field Value to Zero & also changed the VLDB settings of the Metric & as well the Report also (ie) I checked the options for Nulls to be displayed . Can anyone please help me in getting this issue resolved .

Thanks in advance
Cherry

 

[nlim]

if the data is showing up as NULL In your report, then you should stop and restart the server? That might help.

If the data is not showing up in your report at all, then it's probably an outer join issue. Make sure you specify outer join in the grid options for the report.