Hi, Thank you for your feedback. Yes, the key to the lookup table for the rate is taking both origin and convert-to currency codes in along with date. Lookup formula for the Exchange rate logical column is: LOOKUP(SPARSE "Exchange rate ALL"."RATE" , 1,VALUEOF(NQ_SESSION."SV_DLY_DATE_1"), "Dim Transaction…

Thank You for the feedback. I tried PHYSICAL mapping expression and still the same. The thing is that the records are in different currency. In example below they are in RSD and USD. If I put CURRENCY on the report and calcualtions group by CURRENCY the calculation is correct. Example no2. If I don't group by CURRENCY it…

Hi, After I developed this method on development environment and tested with test case data, one thing came up. As it is inner or left join in business model layer, it first SUMs all the data (in my case column VALUE_ORIG) and then multiples with the first rate he gets from lookup table. In example, if I want to show the…

Thank you for the hint of using session variable in LOOKUP function and applying presentation variable value to session variable (request variable).