AnsweredAssumed Answered

Using multiple fields to lookup a specific exchange rate in another table

Question asked by NicoleHartman on Apr 6, 2011
Latest reply on Apr 6, 2011 by NicoleHartman

Title

Using multiple fields to lookup a specific exchange rate in another table

Post

Hi,

I am trying to write a calculation that would evaluate the Currency Code associated with a record and provide back the exchange rate for that record given a date defined by a drop down menu. 

So in one table I have thousands of records that have a currency code associated with product prices and I want to be able to specify a date at the top of the table and then have my calculation evaluate the exchange rate table and provide the appropriate exchange rate by currency code and date for each record. 

Can someone help me with the calculation to achieve this?

Thanks,

Nicole

Outcomes