All Ideas

Idea Details

Upvote Downvote

Post an Idea

4,580 Points

Open

Dako

Ability to choose running users personal settings for currency in reports

Operational Reporting

When creating a report, in the step "Select criteria" under "Advance settings" you have the possibility to choose currency. In this pick list we would like to have an added value, which is the possibility to choose the local currency settings from the running user of the report, which is stated under in the Personal settings for each user.

As it is now, you either choose the currency manually when you create the report or the report will use the corporate currency. This gives us the problem that we need to create a report in each currency that we need the report in. This is especially a problem regarding to our dashboards, since we have a lot dashboards in different currencies, and it would be a great help just to let the report choose the running users currency, so we only need to create 1 report instead of 10.

Merge Idea · Flag

Comments ( 70 )

Sort By

Sabine Lindner - 2 months ago

Please, please, please! We only have three currencies in our Org, but are already running into problems. Please allow for dashboards to show in running user's currency.
- Flag

Madlen Kopp - 2 months ago

Thanks @Evan for sharing this workaround!

I also deleted the currency attribute from metadata.
The issue is: As soon as you save the report again (e.g. adding another filter/field etc.) the currency is again static.

This would be so easy to implement, as metadata is already ready, so please take it into consideration!

Flag

Eleni Barakos - 7 months ago

this would be nice to have(needed) to set in the UI and not just in the metadata
- Flag

Thomas Kluson - 11 months ago

Hello Evan,

interesting discovery. I tested it and can confirm that it works. Thank you for sharing it.
It shows that the feature is actually there, but simply can not be accessed by normal means. Too Bad.

Flag

Evan Ponter - 1 year ago

I found a workaround - the documentation states "In reports, the primary currency reflects either the default corporate currency or the currency selected for the record. The secondary currency reflects the personal default currency of the user running the report, or the currency specified in the report criteria."

Since that last statement is either/or, I thought "what if I remove the currency specified on the report?" I edited the XML metadata of the report in order to remove the <currency> property. I used Visual Studio Code for this after getting CLI set up. Then I deployed this new version of the report back into my org. Now, the "Show > Currencies Using" setting on the report will now automatically toggle to the currency for the user running the report.

It seems this is officially supported based on the documentation, but there isn't a way to set this in the UI. The metadata supports defining a report without a <currency> property, so as long as you can edit the metadata for your report, this should work.

Flag

Donna Charron - 1 year ago

This is a problem, especially for dashboards. We have to recreate the same dashboard with reports for each currency.
- Flag
Brage Vik - 1 year ago

We need this, yesterday. Same for Dashboards.
- Flag

Maud EON - 1 year ago

Another similar ticket was created for this request https://success.salesforce.com/ideaView?id=08730000000jYaUAAU
Merging all the requests would make this ticket viable for dev!
Urgently needed in my international organization as well for reports and dashboards.
Thanks

Flag

David Walker - 1 year ago

As a variation on the idea, we would like to be able to dynamically assign the currency based on a field variable. We have projects in different currencies, for a single office, so just using the user currency settings will not be sufficient.

Flag

Thomas Kluson - 2 years ago

Another idea, same topic: https://success.salesforce.com/ideaView?id=08730000000ZCYWAA4. Should be merged.
- Flag
Peter Mandy - 2 years ago

100% Need this. Cloning reports and dashboards for each currency is a long-winded workaround.
- Flag

Kristine Curington - 2 years ago

We have 6 currencies enabled in our org. We want to have a dashboard display the currency based on the running user's default currency. Does SF expect us to create 6 dashbards so that we can have a dashboard for each currency?

Flag

Ownly Conseil - 2 years ago

Hi Thomas,

In our case, the main report is filtered by "My Opportunies". hence, it made sense to use the "Owner.Currency__c". However, I'd imagine in some cases you might need to use the $User.Currency__c".
Anyhow please let me know the solution worked out in the end!

Best Regards

Flag

Géraldine ANDERSON-GOUBET - 2 years ago

Yes, a dynamic dashboard in user local currency would be great as dynamic dashboard!!!
- Flag

Thomas Kluson - 2 years ago

Hello Rod, thank you for this. I have tested step 1 to 3 from your instructions, and it worked. I am wondering why Salesforce allows us to access "DefaultCurrencyIsoCode" within a process, but not within a formula. Strange ...

Regarding step 4: I assume this formula field should be created in the object, where currency amounts need to be converted, e.g. in object "Account"? Right? In the formula you use "Owner.Currency__c". Shouldn't we rather use "$User.Currency__c" instead?