1. User's Guide
  2. Working With Grids
  3. Formatting Grids
  4. Formatting Numbers in Grids

Formatting Numbers in Grids

When you format how numbers are displayed in a grid, you can define the formatting options for an entire grid or for individual cells, rows, or columns:

To format numbers in a grid:

  1. In the Report Designer, select one or more cells, or select the entire grid.
  2. Select Format, and then Cell.
  3. In the Format Cells dialog box, in the Number tab, define the following options:

    • Positive Number Symbols—Select a prefix or suffix for positive numbers.

      Note: If you need more than one symbol in the prefix or suffix, you can select the first symbol from the drop-down, but you must manually enter any additional symbols.

    • Negative Number Symbols—Select a prefix or suffix for negative numbers. To display negative values in red, select Display in Red.

      You can use a prefix to reverse the sign of an account member without inserting another row or column. When using conditional formatting, you specify an account row and set the condition. Then, in the Negative Number Symbols prefix field, select the negative (-) symbol. The negative (-) symbol is displayed in front of the numbers for that row.

      Note: If you need more than one symbol in the prefix or suffix, you can select the first symbol from the drop-down, but you must manually enter any additional symbols.

    • Decimal Places—Select a number from 0 to 9 to specify the number of decimal places to apply to a number.

    • Separator Characters—How to define separator characters:

      • Defined by Preferences—Use the symbols specified in the user Preferences dialog box in the Oracle Hyperion Financial Reporting repository. (In the repository, select File, then Preferences, and then Financial Reporting, and the Financial Reporting Studio).

      • Defined in Report—Define a thousands separator and a decimal separator for the current report.

    • Scale Value By—Number to multiply values by for scaling purposes.

      You can enter a number, or you can select a value from the drop-down list. The default scaling option is 1, which does not scale values. If you enter .001, the value 2,000 is displayed as 2.

  4. Click Apply, and then click OK.