2 Replies Latest reply: Jan 21, 2014 2:07 PM by Srikanth P RSS

    Script calculation

      Hi,

       

      I have 3 files with data in multiple currencies and 1 file with the Currency Rates.

      I would like to have the script to look at the Currency field in the data table(s), find the corresponding Rate in the Currency Table and calculate the Euro rate, the have the result of that calculation show up as a column.

       

      I'm still pretty new at this, so can anyone give me some pointers on how to do this? So far, all my attempts have failed.

      Would be much appreciated.