Number functions

Note: The locale also influences the output of some Number functions; see Locale.

Tip: For fields that contain a number, you can also enter a formatting pattern via the Helper Wizard and the Text Script Wizard; see Using the Helper Wizard, Using the Text Script Wizard, Formatting variable data and Number patterns).

Note: In output, spaces in a number or amount of money are transformed into non-breaking spaces to ensure that it is not split onto different lines.

Note: In OL Connect CEF, formatting is based on the latest CLDR standard. This means there may be differences in the way numbers and dates are formatted, compared to previous versions of OL Connect.
Currencies now consistently use standard-currency rather than accounting-currency, which means negative values are not enclosed in parentheses by default, but instead have a minus sign.

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