In list A I have three columns; Currency, Value and USD value. In list B I have two columns; Currency and Exchangerate.
The currency column is a choice column and based on this column I want to calculate the USD value by finding the appropriate exchangerate in list B and multiplying this with column Value in list A.
How can this be done? I am new to SharePoint and much appreciate your help.