@Hunter I had the same issue a couple days ago.. You should use a formula to divide amount by amount (foreign currency), with that you have the exchange rate you are trying to find.