Download Hyperion Planning System - UBC Information Technology

Transcript
Campus-Wide Budgeting System
User Guide
If you select ―Currency Setting‖, the currency values in the data form are displayed using the
formatting initially set for individual currencies. If you select another option, your selection
applies to all currencies, in all data forms to which you have access in the current application.
You can control the display of:

The thousands separator (none, comma, dot, or space)

The decimal separator (dot or comma)

The display of negative numbers (a minus sign before or after the number, or the
number surrounded by parentheses)

The displayed color for negative numbers (black or red)
To change the formatting of displayed numbers:
1. Click File, then Preferences.
2. Click the Planning icon and select Display Options.
3. Under ―Number Formatting‖, select options, as summarized in this table:
OPTION
Thousands Separator
EXAMPLE
None: 1000
Comma: 1,000
Dot: 1.000
Space: 1 000
You can enter values with or without a thousands separator.
Decimal Separator
Dot: 1000.00
Comma: 1000,00
You can enter values with or without a decimal separator.
Negative Sign
Prefixed Minus: -1000
Suffixed Minus: 1000Parentheses: (1000)
Negative Color
Black: Negative numbers are black
Red: Negative numbers are red
4. Click Save.
Note:
Formatting selections take effect when you click outside the cell. If you
select a setting other than “Use Application Default” for the thousands
separator or the decimal separator, you must change both separators with
the “Use Application Default” option. You cannot select the same option for
the thousands and decimal separators.
27