Hi,
We have an amount field with data type “currency” on our company object. The currency of that field may vary, some use EUR, USD, INR, CAD, SEK etc. When including this field in the “Mass Edit” report type the amounts are displayed in different currencies (the ones originally stored on the company) which makes it hard to compare, filter or sort.
It would be helpful to be able to select a preferred currency, or use the currency of the logged in user to calculate the amounts to the same currency in the report.
thanks!
/David
That said, sorting and filtering can be done based on the user-level currency. We convert to the desired currency and then sort/filter.
Regards,
Shantan