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. |