Page Comparison

Sub Format

Depending on the format option you have chosen for the column above you will have a separate set of sub format options. Select the appropriate sub format option.

Date Other

If you select ‘Other’ from the date sub format you will be able to build your own custom date format.
For example to create a Japanese date format which includes characters, eg.２００３年４月２ 日 would be created by adding in:
yyyy年M月d 日

Decimal Places

If you have a defined a numeric format you can set the number of decimal places to be defined. This can be used to define cents in a decimal place for $20.00 by adding in:
2
Note: To convert numeric data by doing divide by 1,000 calculations etc you would use the data conversion options in advanced functions which are available on the Report Fields page.

See Advanced Functions for more information.

Prefix

The prefix is used to include additional characters before the value that is returned from the data base. This can be used to define currency for $20.00 by adding in:
$

Suffix

The suffix is used to include additional characters after the value that is returned from the data base. This can be used to define percentage for 30% by adding in:
%

Rounding

The rounding format allows you to choose how a decimal value should be rounded.

Thousand Separator

Turns the defaulted thousand separator for your instance on or off. For example:
1000 to 1,000