FORMAT_NUMBER

Description

FORMAT_NUMBER formats a number as a string with a configurable number of decimal places, decimal separator, and thousands separator. Useful for displaying monetary amounts or other numeric values in a locale-appropriate or house-style format.

Syntax

FORMAT_NUMBER(number, decimal_places?, decimal_sep?, thousands_sep?)

Returns: A formatted string representation of the number.

Example

FORMAT_NUMBER(1234567.891)

This returns '1,234,567.89'.

Example with custom separators

FORMAT_NUMBER(1234567.891, 2, ',', '.')

This returns '1.234.567,89' — useful for European locale formatting.

Example in context

p is Person
FORMAT_NUMBER(p.total_assets, 2, '.', "'")

Returns the total assets formatted as e.g. "1'234'567.89" for Swiss-style display.