Skip to main content

Num - script and chart function

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

Syntax:  

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

Return data type: dual

The Num function returns a dual value with both the string and the number value. The function takes the numeric value of the input expression and generates a string representing the number.

Arguments:  

Argument Description
number

The number to be formatted.

format String describing how the resulting string is to be formatted. If omitted, the number format set in the operating system is used.
dec_sep String specifying the decimal number separator. If omitted, the MoneyDecimalSep value set in the data load script is used.
thou_sep String specifying the thousands number separator. If omitted, the MoneyThousandSep value set in the data load script is used.

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!