Num# function

Thu, 30 Oct 2014 15:24:01 GMT

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

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

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

Even this default script setting as well

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

Many Thanks

Re: Num# function

its_anandrjs — Thu, 30 Oct 2014 15:33:27 GMT

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

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

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

Regards

Anand