Multi-Currency Impact on Reports and Dashboards

Flat Reports

The currency field(s) in these reports display the currency values at the record level, this means you can see the Currency ISO Code of that record in addition to the currency value (number).

Aggregated Reports

The currency field(s) in these reports display the currency values as per the currency code defined at User level, and if the user didn’t define any currency code, the aggregated reports display the currency values as per the Corporate currency code. The User defined Currency ISO code is shown in the report, for each record/currency value.

• For information on how to set User Level Currency code, refer to the User Default Currency section of the Multi-Currency Support article.
• For information on how to set Corporate Currency code, refer to the Currency Management Configurations section of the Multi-Currency Support article.

Filters

The data in reports when filtered (both Flat and Aggregated reports) on currency fields using any of the Currency Codes added to the Currency Management page, it is filtered based on the monetary value. This functionality is the same in Reports and Dashboards (Global) filters.

Ranking 

When you apply Ranking in a report (both Flat and Aggregated reports) that has multiple currencies in it, the sorting happens based on the monetary value. 

Sorting

Sorting in reports with multiple currencies happens based on the monetary value. 

Note: Sorting happens on the Server side, where you can search for the records on the entire dataset in the Server side and not just from the data available on the UI/browser. 

Search

Search in reports with multiple currencies happens based on the actual value (search value) but not the monetary value.

Decimal Points

By default, the currency values in a report displays 2 decimals unless defined by the admins in the Field settings. 

Joins

While creating reports, assume you have added a currency field from a lookup object, the report displays the currency value as per the currency code defined in the lookup object. For example, you created a report on a base object Company for which the currency code configured is INR, and you want to add a currency field from the lookup object User for which the currency code is USD, the currency field when added to the report displays the currency values in USD (currency code of User). 

Exports

Exports here include CSV, Excel, PPT, Dashboard and Success Snapshots.

Flat reports when exported display the currency values at record level. The aggregated reports when exported display the currency values as per the currency code that is defined at User level, and if the user didn’t define any currency code, the reports display the currency values as per the Corporate currency code.

Salesforce Objects

Following are the functional differences you see in the reports created on Salesforce objects:

• Filters: In the reports created on Salesforce objects, the data when filtered on the currency field applies filters based on the number but not on the monetary value.
  Note: The currency code dropdown list is not shown, and you cannot select any currency codes.
• Sorting: Sorting in reports with multiple currencies happens based on the number but not on the monetary value.
  Note: Sorting here happens only from the data available on the UI/browser.