I have a chart that has a number that looks like $.18.95
When I send it to Excel the number looks like $18.95
When I put my mouse over the number it changes to 18.9456
I want it to display as only two decimals not four. Can this be done.
Are you using Numbers tab from chart properties to define the number format or are u defining the number format within your expression itself using Num() function?
I have tried both and cant get either to work. The field is called trnstotalcost. In the expression I tried:
Any suggestions as to which one is better.
I think for the export to work, you need to do it in the export tab. Num() does it only for the QlikView viewing, as soon as you export the format will go away.
For that you can use round()
you can try to set in the way you prefer these variables in the script editor:
SET MoneyFormat='$ #.##0,00;-$ #.##0,00';
This is interesting, can you post sample file?
Retrieving data ...