Num# function

[#1]

Could you please explain how to read interpretation function. ex from help

num#( A, '#' ) where A=35,648.375 returns:

	Setting 1	Setting 2
String	35,648.375	35648.375
Number	-	35648.375

num#( A, '#.#', '.' , ',') where A=35,648.375 returns:

	Setting 1	Setting 2
String	35,648.375	35,648.375
Number	35648.375	35648.375

Even this default script setting as well

SET MoneyFormat='£#,##0.00;-£#,##0.00';

Many Thanks

[its_anandrjs]

In QV help

                         Default setting 1            Default setting 2

Number format           # ##0,#                     #,##0.#

When use this expression  num#( A, '#' ) where A=35,648.375 returns: then according to the Default settings it returns

	Setting 1	Setting 2
String	35,648.375	35648.375
Number	-	35648.375

Same here according to default number format settings  num#( A, '#.#', '.' , ',') where A=35,648.375 returns: it returns below

	Setting 1	Setting 2
String	35,648.375	35,648.375
Number	35648.375	35648.375

And this is a SET MoneyFormat='£#,##0.00;-£#,##0.00'; Money format with separators also

Regards

Anand