Customer wants to build a simple non- aggregated report on Opportunity object to view expansion Opportunities of current quarter. Since they have multiple currencies it is not possible to view opportunities based on the revenue field when sorting.
Even if I use ranking to pull top ‘N’ opportunities based on revenue field, it is ranking based on the numbers ignoring the monetary values.
Though this can be achieved by creating SFDC formula field to convert and store all currencies in single currency or by building a rule to convert all of them to corporate currency, it would be great if there is option with in report builder to select the currency for currency data type fields, so that all the values get converted to selected currency and makes it flexible to add these reports in dashboards.
Best answer by jean.nairon
So, if your customer is in the SFDC version, they could create the report with the Amount (converted) field to show the data in the corporate currency. They will unfortunately not be able to show the local currency but it will at least be normalized.