Print this page

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

promote demote