Allow multi-currency fields to be exported as numbers OR with currency symbol vs. ISO code
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 😊