amount

Use the amount function to convert a number into a notation representing an amount of currency. The output is localized based on the current output language.

 amount ( input )

This function returns a value of type TEXT.

The function has one parameter:

• input, type NUMBER. The amount to be converted.

The input value is rounded to cents.

Examples

amount (0.12) results in "0.12"

amount (-0.12) results in "-0.12"

amount (1234567.89) results in "1,234,567.89"

amount (1234567.89) results in "1.234.567,89" (output language NLD)

amount (12.344) results in "12.34"

amount (12.345) results in "12.35"