You need to sign in to do that
Don't have an account?
RSomani
Get Current Dated Exchange Rates in a Formula Field
Hi,
How to get Current Dated Exchange Rates in a Formula Field in a multi-currency enabled system.
I have applied below formula but it is returning Corporate Currency Rate not the Current active rate.
CURRENCYRATE(Text(CurrencyIsoCode))
Please suggest.
Thanks
Romesh
How to get Current Dated Exchange Rates in a Formula Field in a multi-currency enabled system.
I have applied below formula but it is returning Corporate Currency Rate not the Current active rate.
CURRENCYRATE(Text(CurrencyIsoCode))
Please suggest.
Thanks
Romesh
A formula function 'CURRENCYRATE(IsoCode)' is now available. Haven't found any documentation on this but is simple to use. Just make reference to the IsoCode in the formula and it returns the exchange rate.
I put together an article that gives a little more detail on this function -
- http:// http://getawayposts.com/spring-18-release-9-new-functions-that-got-forgotten-in-the-release-notes. (http://http://getawayposts.com/spring-18-release-9-new-functions-that-got-forgotten-in-the-release-notes.)
Don't hesitate to drop me a note if you have any questions.For more informaiton please check with below link which might help.
- https://success.salesforce.com/answers?id=9063A000000DkvsQAC
Please let us know if this helps.Thanks,
Nagendra