Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
-
num#( A, '#.#', '.' , ',') where A=35,648.375 returns:
Even this default script setting as well
SET MoneyFormat='£#,##0.00;-£#,##0.00';
Many Thanks
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