1. User's Guide
  2. Working with Ad Hoc Grids
  3. Ad Hoc Grid Options
  4. Replacement Options

Replacement Options

Data cells in ad hoc grids may contain missing data or data that you do not have permission to view. In such cells, ad hoc by default displays #MISSING or #NoAccess, but you can change these labels.

Table 4-4 Replacement Options

Option Description
#MISSING/#NoData Replaces, in data cells missing data, a user-defined option. The default value is #MISSING.
#NoAccess Replaces, in data cells in which you do not have access permissions, a user-defined option. The default value is #NoAccess.
Submit Zeros

If selected, specifies a zero (0) as a replacement value instead of #MISSING.

Note:

This occurs only for cells in which you manually changed the value to #MISSING.