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