2 Replies Latest reply: Jul 15, 2013 12:59 AM by Femi Adeniyi RSS

    Creating Selection Aware Running Total

    Femi Adeniyi

      Hi All,

       

      I have a somewhat difficult challenge. The attached excel contains 2 tables. transaction & Exrate tables.

       

      Each transaction is stamped with a given currency. The amount per line must be multiplied by the appropriate exchange rate to get the local amount. ie each line will have a calculation of Amount * ExRate.

       

      My main challenge is how to pick the ExRate based on the transaction date. eg, S/No 1 in the excel sheet is a USD transaction on 19 Apr 2007. The correct exchange rate at this date is 31 Mar 2007 with a value of 158.96.

       

      How do I create a pivot/straight table to show this results?

       

      TIA

       

      Femi