Share via

Select Format Override cell

  • Article

The Format Override cell specifies the print format for the row. This numeric format overrides the formatting that is specified in the column definition and the report definition, which, by default, is currency. If the report lists the number of assets in one row, such as the number of buildings, and their monetary value in another row, you can override the currency formatting and enter numeric formatting for the row that specifies the number of buildings.

Specify this information in the Format Override dialog box. The available options depend on the format category that you select. Example formats are displayed in the Sample area of the dialog box For more information, see the procedure in Select Format Override cell in row definition.

The available format categories are as follows:

  • Currency formatting

  • Numeric formatting

  • Percentage formatting

  • Custom formatting

Select Format Override cell in row definition

Override cell formatting

  1. In Report Designer, open the row definition to modify.

  2. In the row for which you want to override the format, double-click the cell in the Format Override column. The Format Override dialog box opens.

  3. In the Format Override dialog box, select the formatting options to use for that row in the report.

  4. Click OK.

Currency formatting

Currency formatting applies to a fiscal amount and includes the currency symbol. The following options are available:

  • Currency symbol – The currency symbol for the report. This value overrides the Regional Options setting for the company information.

  • Negative numbers – Negative numbers can be displayed with the minus sign (−), in parentheses ( ), or with a triangle (∆).

  • Decimal places – The number of digits to show after the decimal point.

  • Zero value override text – The text to include in the report when the amount is zero. This text appears as the last line in the Sample area.

Note

If printing is suppressed for zero values or no period activity, this text is also suppressed.

Numeric formatting

Numeric formatting applies to any amount and does not include a currency symbol. The following options are available:

  • Negative numbers – Negative numbers can be displayed with the minus sign (−), in parentheses ( ), or with a triangle (∆).

  • Decimal places – The number of digits to show after the decimal point.

  • Zero value override text – The text to include in the report when the amount is zero. This text appears as the last line in the Sample area.

Note

If printing is suppressed for zero values or no period activity, this text is also suppressed.

Percentage formatting

Percentage formatting includes the percent sign (%). The following options are available:

  • Negative numbers – Negative numbers can be displayed with the minus sign (−),in parentheses ( ), or with a triangle (∆).

  • Decimal places – The number of digits to display after the decimal point.

  • Zero value override text – The text to include in the report when the amount is zero. This text appears as the last line in the Sample area.

Note

If printing is suppressed for zero values or no period activity, this text is also suppressed.

Custom formatting

Use the custom format category to create a custom format override. The following options are available:

  • Type – The custom format.

  • Zero value override text – The text to include in the report when the amount is zero. This text appears as the last line in the Sample area.

The type should represent both the positive, and then the negative value. Typically, you enter a similar format differentiating between positive and negative values. For example: 0.00;(0.00)

The following table shows custom formats that can be used to control how your values should be formatted. These examples start with a value of 1234.56.

Format

Positive

Negative

Zero

0

1235

-1235

0

0;0

1235

1235

0

0;(0);-

1235

1235

-

#,###;(#,###);“”

1,235

(1,235)

(blank)

#,##0.00;(#,##0.00);zero

1,234.56

(1,234.56)

zero

0.00%;(0.00%)

123456.00%

(123456.00%)

0.00%

Note

If printing is suppressed for zero values or no period activity, this text is also suppressed.

See Also

Row definition