|
|||
Number functionsThe locale also influences the output of some Number functions; see Locale.
For fields that contain a number, you can also enter a formatting pattern directly in the Text Script Wizard; see Using the Text Script Wizard, Formatting variable data and Number patterns).
currency(value)Formats a number as an amount of money. Which currency symbol and which thousands separator are used depends on the Locale; see Locale. value A number. This can be a value from a field that contains a SmallInteger, BigInteger, Float, SmallCurrency or LargeCurrency. currency(value, pattern)Formats a number as an amount of money using a custom pattern. Which currency symbol and which thousands separator are used depends on the Locale; see Locale. For available patterns, see see Number patterns. value A number. This can be a value from a field that contains a SmallInteger, BigInteger, Float, SmallCurrency or LargeCurrency. pattern A custom pattern that may consist of symbols; see Number patterns. Note that the repetition of pattern letters plays a part in determining the exact presentation. currencyNoSymbol(value)Formats a number as a currency whilst omitting the currency symbol. value A number. This can be a value from a field that contains a SmallInteger, BigInteger, Float, SmallCurrency or LargeCurrency. grouped(value)Formats a number using a thousands separator. Which separator is used depends on the Locale, see Locale. value A number. This can be a value from a field that contains a SmallInteger, BigInteger, Float, SmallCurrency or LargeCurrency. |
|