Num# - script and chart function

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

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 date 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.

The examples below assume the two following operating system settings:

Number format default setting 1: # ##0
Number format default setting 2: #,##0

Example	Results	Setting 1	Setting 2
Num#( A, '#' ) where A=35,648.375	String:	35,648.375	35648.375
Num#( A, '#' ) where A=35,648.375	Number:	-	35648.375
Num#( A, '#.#', '.' , ',') where A=35,648.375	String:	35,648.375	35,648.375
Num#( A, '#.#', '.' , ',') where A=35,648.375	Number:	35648.375	35648.375
Num#( A, '#.#',',','.' ) where A=35648.375	String:	35648.375	35648.375
Num#( A, '#.#',',','.' ) where A=35648.375	Number:	35648375	35648375
Num#( A, 'abc#,#' ) where A=abc123,4	String:	abc123,4	abc123,4
Num#( A, 'abc#,#' ) where A=abc123,4	Number:	123.4	1234

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 – please let us know!

Leave your feedback here