I have enabled our multiple currency feature in order to update multiple currency rate values. We want to give a user the ability to view a field's value in another field in which they decide the currency.
In other words, they would fill out a field called "Revenue" which would always be displayed in USD. They would then choose a currency in a picklist field ("International Currency") - and an equivalent currency amount would be displayed in another number field ("International Revenue"). The "International Revenue" amount would be calculated based on the currency's current rate according to the "Revenue" (USD value).
I would like to display the "International Currency" (picklist) and the "International Revenue" (number) together in one field (ie "GBP 1,200,000.00").
What is the best way to go about doing that ? It seems more difficult to do with a simple text formula field if I want the number to be displayed properly (commas etc).
Thank you for your help.