Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
David
Hi,
For that you can use round()
round(sum(trnstotalcost),0.01)
Regards
Try
=Num(18.9456,'##.00')
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:
=num(sum(trnstotalcost),'$##.00')
Any suggestions as to which one is better.
David
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.
HTH
Best,
Sunny
Hi,
For that you can use round()
round(sum(trnstotalcost),0.01)
Regards
Hi!
you can try to set in the way you prefer these variables in the script editor:
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='$ #.##0,00;-$ #.##0,00';
KR,
Elena
Hi,
This is interesting, can you post sample file?