Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a line chart, where Value is showing in two decimal.
However when I am exporting this to Excel the decimal points are increasing in Excel.
Could anyone please help me to solve this.
I am attaching the sample qvw file.
Thanks,
Sarif
Hi,
Attached a new version. Try if now the application is having a correct behaviour.
Thanks,
Hi,
The fact that you are only showing two decimal points in your graph is not the same as the value only having two decimal points. The graph rounds it to what has been set in the 'number' tab, however the raw data remains the same and that is what is being exported.
If you want to ensure that the values only have two decimal points at all times, you should adjust this in the script using the num() function with '# ##0,00' as input.
Hi,
Attached a new version. Try if now the application is having a correct behaviour.
Thanks,
Awsome...thank you so much...