The FormatNumber()
function converts a number to text according to the specified format.
This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.
Returns a new text string that is the formatted text representation of a number.
Returns Invalid expression
if number
is unknown or the indicated format is not valid for numeric values.
If the language
parameter is not specified or contains an unknown value, then the default portal language is used to format the number.
Name | Type | Required | Description |
---|---|---|---|
number
numeric
a value of any type.
decimals
numeric
the number of decimals that are included in the returned text
grouping
yes/no
a boolean that indicates if large numbers are grouped (a separator is used)
language
language keyword
this parameter is used to specify the number representation according to the specified language/culture.