Exporting a report splits amount field into 2 fields for multi currency organizations
|Knowledge Article Number||000181284|
While exporting a report, an amount field is being split into two: a currency field and an amount field. The amount field will display the actual amount, the "new" column for currency will show the currency descriptor (USD, CAD etc)
This is a standard behavior in organizations that have enabled multi-currency. It would have to be changed once the report details were exported to Excel.
Note: When exporting reports and using multi-currency, Excel treats "USD 1355" as a text field and not as a numeric value, so all "Amount" columns will be shown with the currency prefix and cannot be summed.
For getting it fixed up an idea been posted requesting to keep this information in single column: Multi-Currency Double Column Elimination Upon Details Export