Amount formatter
Use the Amount formatter to configure amount formats such as the decimal symbol or the currency character.
-
Navigate to
.
The Field formatters page appears. The two formatters, Default Amount Formatter and Default Date Formatter appear by default.
-
Click
New.
The New field formatter dialog box is displayed.
- By default, a new formatter is added to your working category. To select a different category for the new formatter, select the Category.
- On the Type list, select Amount.
-
Configure the amount formatter settings.
Setting
Description
Analysis amount
Allow negative amounts
Allows negative amounts as valid input. (Default: Selected)
Require decimal points
Requires the input value to have a decimal point. (Default: Selected)
Allow 3 decimal places (1.000 ->1.000.00)
If selected, treats the input values ending in three decimal places as fractions instead of whole numbers. (Default: Clear)
Allow empty field
If selected, allows an empty field to be valid; otherwise, the empty fields are considered invalid. (Default: Clear)
Currency
Allows you to add, modify or delete currency phrases.
To add a currency, click , add the name for the currency, and click Add.
A currency phrase appears on the document next to an amount.
Formatting
Decimal symbol
Identifies the character to use as a decimal symbol. (Default: "<system default>"; the decimal symbol is determined by the operating system of the local computer.)
No. of decimal places
A value between 0 and 4 that defines the number of decimal places used. (Default: 2)
Thousands separator
If selected, large numbers can be formatted to have a thousand separator using a separator symbol. For example, 1000000 can be displayed as 1,000,000. (Default: Clear)
Separator symbol
Available symbols for thousand separator formatting include:
-
<System.Default>: The separator symbol is determined by the operating system of the local computer.
-
"," (Comma)
-
"." (Full stop)
When you apply this formatter to a document or folder field, the value is displayed with the selected formatting applied.
-
-
To test the amount formatter, enter a sample text in the
Sample input text box and
click
Test.
The output appears in the Formatted text field. For example, if No. of Decimal Places = 3 and Currency = EUR, and Sample input text = 28678, the Formatted text appears as "28678.000 Eur".
If TotalAgility cannot format the sample text, for example, if the sample input text is incorrect, a message appears.
- Click Save.