AX1612

Using numeric type for column formatting

You can use the Numeric Type property on a numeric column to specify what type of data that column holds. This property is used by Axiom Financial Institutions Suite to determine the formatting of the column values in certain areas of the software.

The numeric type is only available for the following column data types: Integer (all types) and Numeric. By default, the numeric type is set to Number for all applicable columns. You can change the setting for any column when creating or editing the table.

NOTE: Calculated fields are always treated as Currency type, regardless of the specified numeric type on the columns in the sequence for the calculated field.

Numeric types

The following types are available:

Type Description Formatting Example (1234)

Number

Column values are treated as plain numbers. If the data type includes decimals, two decimal places are included.

1234

1234.00

Currency

Column values are treated as currency values. By default, currency values are displayed with a currency symbol and with a thousands separator. Decimals are not included by default.

By default, the symbol is a dollar sign ($). However, the symbol can be explicitly defined by using the system configuration setting SystemCurrencySymbol. For information on changing system configuration settings, see System configuration settings.

$1,234

Percent

Column values are treated as percentage values and displayed with a percent sign. Decimals are not included by default.

 123400%

Date

Column values are treated as date values. This is a placeholder for future functionality, intended to display valid date serial numbers as dates. Currently this option has no effect.

 N/A

DateTime

 Column values are treated as date/time values. This is a placeholder for future functionality, intended to display valid date serial numbers as date/time values. Currently this option has no effect. N/A

Impacted areas of Axiom Financial Institutions Suite

Places where numeric type is honored include the following:

  • Columns in web reports
  • Columns in the Data Grid component and the Fixed Report component of Axiom forms
  • File group dialogs that use the configured Display Columns for the file group, such as Open Plan Files and Process Plan Files
  • The Process Status dialog (as configured by the Process Columns for the file group)
  • The Plan File Directory and Process Directory pages for file groups (as configured by the Web Configuration settings for the file group)
  • Plan file process notifications, when including a column variable in the notification

NOTE: The numeric type has no effect on column values that are brought into a spreadsheet, such as via an Axiom query or a GetData function. The spreadsheet cell formatting determines the display of numbers in the spreadsheet.