Treating data values as missing
Many data sets use special values (such as "999") to indicate missing values. To exclude such missing values from Wizard's calculations:
- In the Summary view, select the column or columns for which you wish to define missing values
- Choose Column > Define Missing Values...
- Use the predicate editor to define conditions for missingness, and press OK when you are finished
Empty data values are always treated as missing.
See also: