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 information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?