4 Replies Latest reply on Apr 6, 2011 1:04 PM by NicoleHartman

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

    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