3 Replies Latest reply: May 2, 2012 8:01 AM by jagan mohan rao appala RSS

    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

                                       Currency, USDrate

                                            INR,   53.21



      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.