Number functions

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

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.

Note that all values are initially strings (except when a CSV or Microsoft Excel file was loaded). Strings need to be converted to a number before passing them to this function.

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. Note that all values are initially strings (except when a CSV or Microsoft Excel file was loaded). Strings need to be converted to a number before passing them to this function.

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. Note that all values are initially strings (except when a CSV or Microsoft Excel file was loaded). Strings need to be converted to a number before passing them to this function.

grouped(value)

Formats a number using a thousands separator. Which separator is used depends on the Locale, see Locale.

value

A number. Note that all values are initially strings (except when a CSV or Microsoft Excel file was loaded). Strings need to be converted to a number before passing them to this function.