Modify the Format for a Currency Column

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:

1. Click the Columns tab on the Options dialog box. The Format grid column for the report column displays the current format.
2. Click the Format grid column for the report column and click to open the Format Currency dialog box.
3. If you want to use the default number of decimal places, select Use default number of decimal places in the Other options group box.
4. 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.
5. 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.
6. In the Negative number field, specify how you want the report to indicate negative amounts..
7. In the Zero number field, specify how you want the report to indicate zero amounts.
8. If you use Multicurrency, use the Display option in the Currency symbol group box to select an option for displaying currency symbols or currency codes with amounts.
9. In the Location field in the Currency symbol group box, indicate where to display the currency symbol or currency code.
10. Click OK to return to the Options dialog box. The Format grid column displays the modified format.
11. After you set all report options, click Apply.