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. Replacement Options

OptionDescription
#MISSING/#NoDataReplaces, in data cells missing data, a user-defined option. The default value is #MISSING.
#NoAccessReplaces, 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.