AnsweredAssumed Answered

Query Exporting numbers

Question asked by mdc91 on Feb 12, 2019
Latest reply on Feb 12, 2019 by mdc91

Hi everyone.

 

Just wondering if you can help me. I have a script that exports to a .CSV file when prompted. I have all fields with calculations set to display data in 2 decimal format (ie 000.00). However, when exporting from the system it arrives in the .csv as something with a long string of decimals (ie 000.000000000000000).

 

 

Is there anyway I can control the export so that only the 2 decimal points are exported?

Thanks in advance!

Outcomes