SUPMISSINGROWS

Suppresses the display of rows that contain only #MISSING values.

Syntax

{ SUPMISSINGROWS }

Example

<Sym
 <Column (Scenario, Year)
 Actual Budget
 Jan Dec
<Top ("Measures", 5, @DataCol(4))
<Row (Measures, Market, Product)
{SupMissingRows}

<Idescendants Profit
<Ichildren Market
<Idescendants Product
!

This example produces the following report:

                                  Actual            Budget      
                              Jan      Dec      Jan      Dec 
                            ======== ======== ======== ======== 
Sales   Market   Product      31,538   33,342   29,480   30,820 
Margin  Market   Product      17,378   18,435   16,850   17,360 
COGS    Market   Product      14,160   14,907   12,630   13,460 
Sales   Central  Product      10,346   10,662    9,970   10,310 
        West     Product      10,436   11,116    9,460   10,200