Query to get currency values as defined in the CurrencyIsoCode
SELECT Id, CurrencyIsoCode, Amount, convertCurrency(Amount) UserAmount, FORMAT(amount) TextAmount, FORMAT(convertCurrency(amount)) convertedCurrency FROM Opportunity order by CurrencyIsoCode
Visual: https://www.youtube.com/watch?v=eLec5-hcS0s
Comments
Post a Comment