The Current Workspace Settings

Suppress zero values

This option, when selected, suppresses zero values when viewing data in the Table and Summary windows. Suppressed zeros are not printed, but are exported as zero values when the Table or Summary data is exported or copied to any format except text. For text export and copy operations, the suppressed zeros are exported as space characters to retain column integrity.

Note that Monarch Complete implements zero suppression based upon the value that is returned to each cell after any rounding has been done on the value. For example, if you set the precision of a cell containing the value 0.004 to two decimal places, Monarch Complete will round the value to 0.00. Since this value equates to zero, it will be suppressed if zero suppression is turned on. This is not the case in other applications, such as MS-Excel, where the underlying value 0.004 is retained and evaluated against zero. In Excel, the cell would be displayed as 0.00 and would not be suppressed, since its underlying value (0.004) is not equal to zero.

Display nulls as text

Display null values as

This option determines how null values will appear on screen in the Table and Summary windows. You may enter a text string to use when representing null values. The string will be displayed using right justification.

In Monarch Complete, as in most other database applications, a null value represents an unknown value or a value that cannot be calculated. Monarch Complete returns null values under a variety of situations:

• When a calculated field expression causes division by zero.

• When the Minimum or Maximum calculation is used in a summary if no records match the key field values for a cell (e.g., there are no records of media type "CD" for the customer "Bluegrass Records"). In this case, no data is available to the cell.

• When the Standard Deviation or Variance calculation is used in a summary if only a single record matches the key field values for a cell. In this case, there is insufficient information available to perform the calculation.

• When the denominator in a Ratio measure calculation evaluates to zero causing the Ratio calculation to result in division by zero

Monarch Complete exhibits the following behavior when evaluating expressions and calculations that reference one or more null values:

Evaluation

When a null is used in an evaluation, the expression always evaluates to False. This is the case even when a null is evaluated against another null. The reason is that null is treated as an unknown value (when two unknown values are evaluated against each other, it cannot be said that they are equal).

Monarch Complete's expression engine also does not support the constant NULL, so evaluations like the following one cannot be made: If(Amount=NULL, true result, false result)

However, an indirect method of evaluation against null will work in Monarch Complete. For example, let's say that you want to create a filter in the Table window that removes all records where the Amount field value is null. Let's say that you also know that the Amount field values are never likely to be larger than 1,000,000.00 (one million) or smaller than –1,000,000.00 (negative one million). You could use either of the following filter expressions to remove records whose values are null:

Amount>-1000000
or
Amount<1000000

Either expression will evaluate to True for all records that contain a valid value in the Amount field, and will evaluate to False for all records that contain a null in the Amount field (since an evaluation against null returns False).

Calculation

When a null is referenced in a calculated field expression, the result of the expression is null. For example, the expression Amount*0.2 returns the Amount field value divided by 5 for all records where Amount contains a number. For records where Amount contains null, the expression returns null.

When one or more null values are included in a measure aggregation, the null values are ignored. This can produce the desired result or an unexpected result, depending upon your point of view. For example, the Average(Amount) calculation returns the average Amount by dividing the sum of the Amount values by the Count (the number of records from which the function drew Amount values). Records for which the Amount value is null are not included in the calculation. A different result is returned by the Ratio(Amount:Count) calculation, as this calculation tallies the Amount values and the Count values in two steps. First, the sum of the Amount values is calculated, then, in isolation, the Count for all records matching the same key field values is determined. Thus, in a Ratio calculation, the Count represents all of the records, including those whose Amount field contains null.

Highlight null cells

This setting instructs the application to highlight null (as opposed to, for example, blank) cells in the table/summary

Show whitespace characters

This setting instructs the application to show whitespace characters in the table/summary.

Default Row Height

Lines in column title row

This setting determines the default height for column titles in the Table and Summary windows. You may set the height from 1-12 lines. Column titles that are too long to fit on a single line will wrap to fit.

Lines in data rows

This setting determines the default height for data rows in the Table and Summary windows. You may set the height from 1-12 lines. Data values that are too long to fit on a single line will wrap to fit.

Automatic Row Sizing

Automatically increase row heights to fit multi-line data

This setting instructs the application to increase row heights automatically to accommodate multi-line data.

Month-based

Specifies that the fiscal year consists of 12 calendar months.

First month of the fiscal year

Selects the month of which the first day begins the new fiscal year.

Week 1 starts on January 1

Specifies that the first week of the fiscal year begins on January 1.

Each week starts on a specified weekday

Defines the start of a fiscal week and the week number of a partial week.

Week-based

Specifies that the fiscal year consists of 52 or 53 whole weeks. You can specify the first day of each fiscal week, a reference month and day, and a rule for year start or end.

Select to divide the year into four 13-week quarters, then pick one of the following:

• The week distribution pattern is 4-4-5 - Select to specify that each quarter is divided into a period with a pattern of 4 weeks, 4 weeks, 5 weeks.

• The week distribution pattern is  4-5-4 - Select to specify that each quarter is divided into a period with a pattern of 4 weeks, 5 weeks, 4 weeks.

• The week distribution pattern is 5-4-4 - Select to specify that each quarter is divided into a period with a pattern of 5 weeks, 4 weeks, 4 weeks.

The year is divided into four 13-week quarters

Divides the year into four 13-week quarters and allows you to choose a week distribution pattern and quarter and period in which to place the 53rd week if necessary.

The year is divided into thirteen 4-week periods.

Divides the year into thirteen 4-week periods  and allows you to choose a period in which to place the 53rd week if necessary.

Week 1 starts on January 1.

Specifies that the first full week of the year starts on the first day of the week on or after January 1.

Each week starts on a specified weekday

Specifies that the week begins on a specific weekday and allows you to set a week number for a partial week.

Interval

Lists the names of the time intervals available.

Formatting Mask

Displays the formatting mask applied to the adjacent interval. To edit the formatting mask, double-click on the desired time interval, or select an interval and press the Edit Formatting Mask button .

Sample Value

Shows the effect of the formatting masks on today’s date. To change the date that the sample value is based on, adjust the sample date calendar control accordingly. This control is located on the right-hand side of the dialog immediately below the table containing the time intervals.

Description

Displays a description of each time interval.

Margins (inches|centimeters)

The Margins label at the top of the dialog displays the unit of measurement (either inches or centimeters) for all margin settings used in the current Monarch Classic session.

Note: The unit of measurement is determined by the Measurement setting in the International section of the Windows Control Panel.

Top

Accepts a value representing the top margin. The default value is .5" or 1cm, depending upon the Windows Control Panel Measurement setting.

Bottom

Accepts a value representing the bottom margin. The default value is .5" or 1cm, depending upon the Windows Control Panel Measurement setting.

Left

Accepts a value representing the left margin. The default value is .5" or 1cm, depending upon the Windows Control Panel Measurement setting.

Right

Accepts a value representing the right margin. The default value is .5" or 1cm, depending upon the Windows Control Panel Measurement setting.

Show Grid lines

Prints the grid lines between rows and columns, as displayed on screen.

Show Column Titles

Prints column titles at the top of each page.

Repeat Suppressed Values on New Page (Summaries only)

Ignores the "Suppress Duplicate Values" setting for all key fields when printing the first line of each page of a summary. This has the effect of printing all key values for the first line on a page, even if they are suppressed in the summary display.

Paper Size

Select the desired paper size.

Orientation

Select the desired paper orientation.

Page Header display box

Displays a page header of up to 3 lines, each with text left-aligned, centered, or right-aligned text. Enter text into the boxes provided. You can insert special characters and/or variables by clicking on the left arrow button and selecting the item from the list of variables:

• Page number

• Total pages

• Date

• Time

• Filter Name

• Sort Name

• Input Name

• Workspace Name

Use custom font

Click to display the Custom Font button .

Click the Custom Font button to display the font dialog to set font options: