Format Currency Values
These steps explain how to make your Query results easier to read by adding dollar signs to the currency values.
-
The terms file, field, and record may also be referred to as table, column, and row in the context of Queries. For details, refer to the online course CMS 100 - Report Builder: Canned Query.
-
Launch Tool #100 CU*BASE Report Builder (Query).
-
Select the desired options on the Build a Report screen.
-
Click the forward arrow.
-
Select the desired files, fields, records, and sorting options on the Report Builder - Main Menu screen.
-
Click Format Columns.
-
On the Specify Report Column Formatting screen, click the edit button (pencil icon) button corresponding to the field whose currency formatting you'd like to change.
-
Ensure that the Edit option is set to Numeric Editing on the Define Numeric Field Editing screen.
-
Click the forward arrow.
-
On the Describe Numeric Field Editing screen, check the box labeled Show currency symbol.
-
Click the forward arrow.