Money - script and chart function

Money() formats an expression numerically as a money value, in the format set in the system variables set in the data load script, or in the operating system, unless a format string is supplied, and optional decimal and thousands separators.

Syntax:

Money(number[, format[, dec_sep[, thou_sep]]])

Return data type: dual

Arguments:

Argument	Description
number	The number to be formatted.
format	String describing how the resulting money string is to be formatted.
dec_sep	String specifying the decimal number separator.
thou_sep	String specifying the thousands number separator.

If arguments 2-4 are omitted, the currency format set in the operating system is used.

The examples below assume the following default settings:

MoneyFormat setting 1: kr ##0,00, MoneyThousandSep' '
MoneyFormat setting 2: $ #,##0.00, MoneyThousandSep','

Example	Results	Setting 1	Setting 2
Money( A ) where A=35648	String:	kr 35 648,00	$ 35,648.00
Money( A ) where A=35648	Number:	35648.00	35648.00
Money( A, '#,##0 ¥', '.' , ',' ) where A=3564800	String:	3,564,800 ¥	3,564,800 ¥
Money( A, '#,##0 ¥', '.' , ',' ) where A=3564800	Number:	3564800	3564800

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here