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!