Can be used in the property formulas to format a number field (see Number Properties).
Can be used in the property formula of property "Currency Position" to specify where to show the currency symbol relative to number and sign.
| Constant | Example |
|---|---|
| leadingCurrencyInsideNegative | $-123.45 |
| leadingCurrencyOutsideNegative | -$123.45 |
| trailingCurrencyInsideNegative | -123.45$ |
| trailingCurrencyOutsideNegative | -123.45$ |
Can be used in the property formula of property "Currency Type" to define the type of the currency symbol (no symbol, fixed, floating).
| Constant | Example |
|---|---|
| fixedCurrencySymbol | $ 123.45 $ 123 |
| floatingCurrencySymbol | $ 123 $ 123.345 |
| noCurrencySymbol | 123.45 |
Can be used in the property formula of property "Negatives" to specify the style for negatives.
| Constant | Example |
|---|---|
| noNegativeSign | 123.45 |
| leadingMinus | -123.45 |
| trailingMinus | 123.45- |
| bracketedNegatives | (123.45) |
Can be used in the property formula of property "Number Type" to define the type of a number field.
| Constant | Type | Example |
|---|---|---|
| integerNumberFormat | Whole number only | 123 |
| fractionalNumberFormat | Number including its decimal digits | 123.00 |
| percentNumberFormat | Number multiplied by 100, with a percent sign | %123 |
| currencynumberformat | Number including currency symbol | $ 123 |
| useCustomFormat | Custom format | Allows you to set the format properties yourself. |