Num#

- script and chart function

Num#() converts a text string to a numerical value, in the number format set in the data load script or the operating system. Custom decimal and thousand separator symbols are optional parameters.

Syntax:  

Num#(text[, format[, dec_sep [, thou_sep ] ] ])

Return data type: dual

Arguments:   

Argument Description
text

The text string to be evaluated.

format String describing how the resulting date 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 DecimalSep value set in the data load script is used.
thou_sep String specifying the thousands number separator. If omitted, the ThousandSep value set in the data load script is used.