Sample script file: ZeroValues.mrs

Creating a frequency table and defining cell contents explains that the default character for zero percentage values is - (hyphen). You can define six separate special characters to be displayed instead of 0 for zero counts, percentages, and other cell contents, and for counts, percentages, and other cell contents values that are rounded to zero, respectively. You can use any string for these characters and you define them using the table properties. You can define these characters for individual tables or as defaults to apply to all new tables.

You can also hide rows and columns in which all of the values are zero by defining hide rules or manually removing the rows and columns from the table.

The examples in this topic assume that you have already created the Table Document object and loaded the Museum sample data set as shown in Creating a simple table of Age by Gender. The examples create tables using the education and before variables, which both have a Not answered category that was not selected by any respondents.

First, create a table that shows zero values as asterisks:

The last two lines set the table’s ZeroCountSymbol and ZeroPercentSymbol properties to * and **, respectively. This means any true zero count values in this table are displayed as a single asterisk, and any true zero percentage values in this table are displayed as two asterisks.

If you want to use these symbols in all tables, you could set the default properties rather than the properties on each individual table. Changing the default properties does not affect tables that have already been created. This means that if you want the new default setting to apply to your table, put the line that sets the defaults before the line that creates the table, like this:

You can set a different display value for counts and percentages that are rounded to zero using the RoundZeroCountSymbol and RoundZeroPercentSymbol properties. The default value for these properties is an asterisk. For a list of other properties that you can set on individual tables or as table document defaults, see Table properties.

Here is the table produced by the script:

The following table has two hide rules, to hide rows and columns in which all of the values are zero.

Here is the table produced by the script:

Details of the hide rules are shown in a footer. For more information, see Annotations.

Instead of defining hide rules to hide zero values, you can set up hide rules to hide values greater or less than a certain value. In addition, you can set up default hide rules to apply to all new tables.

An alternative method of hiding rows or columns is by explicitly removing them from the axis. For example, the following example actually removes from the table the row and column for the two Not answered categories:

Here is the table produced by the script:

UNICOM Intelligence Reporter