NVL() function in Crosstabs not working

The Oracle NVL() functions doesn't seem to work in Crosstab- still see blank cells.

This function is applied at the detail rather than summary level (used in most Crosstabs) and so, depending upon the measures/calculations/aggregation being used, may not be applied.

Resolving the problem

1. Select the Crosstab Measure, Properties > Data Format > Number > Missing Value Characters > set this to 0.

or

2. Create a new calculated measure that uses the 'is missing' operator based on the original measure, for example:

if ([Quantity] is missing) then (0) else ([Quanatity])

Then Cut (don't Delete) the original measure so that only the calculated Measure appears in the Crosstab.