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.