Skip to main content
jenlpro
Helper ⭐️
November 29, 2022
New Idea

Allow multi-currency fields to be exported as numbers OR with currency symbol vs. ISO code

Related products:CS Reports
  • November 29, 2022
  • 1 reply
  • 54 views

A lot of our team relies on drill down extracts for ad-hoc reporting, and because we are a mutli-currency instance, we have to manually add a column or columns to our Excel or GSheet and use the “Split Text to Columns” function to break the ISO code out from the same cell as the currency value. I would love it if any of the following changes were made to make multi-currency drilldowns and reporting more user-friendly:

  • If any currency field(s) is added to a report, automatically add the ISO code field as a separate field to the drilldown
  • If any currency field(s) is added to a drilldown, allow a field-specific setting to export with symbol vs ISO (ie instead of USD 50000.00, export as $50000.00)
  • If any currency field(s) is added to a drilldown, default the export to use symbol

There may be an even better or easier solution that the options I listed above and I’d love to hear what other people think, but this is such a huge pain for my team right now. Anything we can do to make this easier would be much appreciated 😊

1 reply

Jef Vanlaer
Helper ⭐️⭐️⭐️
July 23, 2025

Exports of currency fields are very hard to work with today. Lots of manipulations needed before you can use these fields further in Excel...