table#1:

id, date, customer, value, currency

I have another table that contains the exchange rates

table#2:

month, year, currency, exchange_rate

I want to add a new custom formula column to table#1 which basically calculates as follows:

CALCULATE 

- table#1.value x table#2.exchange_rate

WHERE

- MONTH(table#1.date).'/'.YEAR(table#1.date) = table#2.month.'/'.table#2.year

- table#1.currency = table#2.currency

Can this be done with Zoho Reports and if so, where do I start???