How to retreive data from table/qvd and do calculation in expression itself?
I have 2 tables in these way;
table 1: revenue
Date, Country, Revenue, Currency
24-4-2011, India, 1000, INR
table 2: USDconversion rate
Now i want to write the expression for table which add Revenue_in_USD as row in same table. Expression should take USDRate from USDconversion table and revenue from revenue table and then convert into USD.