2 Replies Latest reply: Feb 11, 2015 3:15 AM by Settu Periyasamy RSS

    Exchange rate conversion

    Settu Periyasamy

      I have the 3 tables

      1st table contains : Customer, Product, Loaded_Currency and List Price.

      2nd table contains : EFF_Currency, EFF_CUR_TO, Exchange Rate

      3rd table contains : EFF_Currency, Product, Effective Price.


      1st table sample data:

           

      2nd table data:

      3rd Table:

       

      Now, I need the chart like the Below (Need to shows the two Products and effective price also based on Exchange rate)

      i used the expression like the below

      =Only([Effective Price])*Only({<EFF_CUR_TO={'$(=Loaded_Currency)'}>}[Exchange Rate]).

       

      But, the result, shows as null... I attached the sample app..

       

      Can you help on this?

       

      Regards,

      Settu P