Calculated Column expression

[Anonymous]

I have two tables. Project table and Currency table. Both are joined by the column "CurrencyISOCode" which is present in both the tables. My requirement is to divide the Project.Amount by Currency.ConversionRate based on the "CurrencyISOCodes". Please suggest an expression for a calculated column for this. 

[Greg_Deckler]

So, is that a 1:1 relationship or? What does your Currency table look like assuming what you posted is the Project table?

[Anonymous]

Hi Greg, 

Thanks for your reply. Here is my Currency Table. It is a 1:M relationship as CurrencyISOCode is present only once in "Currency Table" but is present numerous times in "Project" table.