I have a multi-currency field on Opportunity product that looks like this - Total Price 1 EUR (1.19 USD)

The main currency is USD and if the price is in another currency it automatically converts it.

I need to create a formula field that from the Multi-Currency Total Price field pulls out only the converted USD value That I can later on use for other calculations.

I tried this formula TotalPrice / CURRENCYRATE( TEXT(CurrencyIsoCode) )

The problem with this was I constantly get returned the current conversion rate for this month, so I cant use it, I actually need to extract the USD amount that it would have been when Opportunity was closed with that period's exchange rate, so I need a way to just extract it from the Total Price field, rather than converting it once more.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.