I would like the currency on a report to dynamically change depending on the current user running the report in a multi-currency enabled org. Is there a way to accomplish this? I've looked around online for ideas and while there is a similar post in the Ideas forum of the dev boards, I haven't had much success.

As an alternative I am looking at creating a different report for each currency in question but would like a cleaner solution.

  • Your title says manager, your post says user. Which one is it? I always thought that reports already changed based on the user itself... – Sebastian Kessel Oct 11 '16 at 20:35
  • I would like the manager to see a report which would include subordinates Opportunity numbers (which could be in EUR, etc) in that managers' regions' currency, which would be USD for example. USD may not necessarily be the "global" currency of the org in this example. Hope this helps! – Joshua__c Oct 11 '16 at 20:46

You're describing Salesforce's default behavior.

Amounts in reports are shown in their original currencies, but can be displayed in any active currency. You can change the currency used for report totals by selecting a currency from Show | Currencies. The default value is your personal currency. For any amount, you can choose to display the Converted column—for example, Annual Revenue Converted—which shows amounts in the currency you select.

Emphasis added is mine

Documentation is here

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.