The Layout tab in the Options dialog box for a report displays the default currency format for the report. That format is the default format for each currency field on the report. On the Columns tab of the Options dialog box, you can modify the format for individual columns.
For the Key Financial Metrics report, you can define metric formats for individual metrics on the Metrics tab in the same way that you do for columns on the Columns tab for other
Vision reports.
To modify the format for a currency column, complete the following steps:
-
Click the Columns tab on the Options dialog box.
The
Format grid column for the report column displays the current format.
-
Click the
Format grid column for the report column and click
to open the Format Currency dialog box.
-
If you want to use the default number of decimal places, select
Use default number of decimal places in the
Other options group box.
-
If you want to use a different number of decimal places, clear that check box, and select or enter the number of decimal places in
Decimal places.
In some cases,
Vision uses a fixed number of decimal places for a column. If you specify a different number, it has no effect on the format of amounts in those columns.
-
For the
Digit grouping option, select either no grouping or the default grouping for the applicable culture.
For example, if the culture for the report displayed in the
Override regional settings field on the Layout tab is
English (United States), this option is
123,456,789.
-
In the
Negative number field, specify how you want the report to indicate negative amounts..
-
In the
Zero number field, specify how you want the report to indicate zero amounts.
-
In the
Location field in the
Currency symbol group box, indicate where to display the currency symbol or currency code.
-
Click
OK to return to the Options dialog box.
The
Format grid column displays the modified format.
-
After you set all report options, click
Apply.