Null values are used to represent values that are ether undefined or are considered to be in error. Null values are returned by Monarch under a number of scenarios, including the following:
A calculated field expression causes division by zero. In this case, the result (infinity) cannot be represented, so a null is returned.
Use of the Minimum or Maximum calculations in an across summary where no records match the key field values for a cell (e.g., there are no records for the media type "MD" for the customer "Bluegrass Records"). In this case, no data is available to the cell, so a null value is returned.
Use of the Standard Deviation and Variance measure calculations when only a single record matches the key field values for a cell in a summary. In this case, a zero value would not be appropriate, so a null value is returned.
Use of the Ratio measure calculation when the dividend contains the value zero, resulting in a division by zero. In this case, a zero is inappropriate, so a null is returned.
A null value is imported from a database-style input, such as a SQL database.
The default string used to represent null values in Monarch Classic's Table and Summary windows is "(Null)", but you can specify any string you like via the View tab, Options dialog.