Handling Records With Missing Field Values

Missing data is defined as data that is missing from a report because it is not relevant or does not exist in the data source. Report output that involves averaging and counting calculations or the display of parent segment instances may be affected by missing data. Data can be missing from reports and calculations for the following reasons:

• Data is not relevant to a particular row and column in a report. See Irrelevant Report Data.
• A field in a segment instance does not have a data value. See Missing Field Values.
• A parent segment instance does not have child instances (missing segment instances). See Handling a Missing Segment Instance.

Note: To run the examples in this topic, you must run the stored procedures EMPMISS and SALEMISS to add missing data to the EMPLOYEE and SALES data sources, respectively.