4 Replies Latest reply on Aug 1, 2018 12:19 AM by Thomas Kont

    Dynamic Currency Conversion Calculated Field

    Thomas Kont

      Hello,

       

      I have a problem with currency conversion. 2 source data.

       

      1. Planned Cashflow

      2. FX Spot Rate

       

      I want to be able to convert all Cashflows from its Transactional Currency to its Group Currency by dividing the Cashflow in TC with the FX Spot rate on a daily frequency. The first data source is aggregated, while the 2nd is not. I have tried many things but not successfully yet. Could someone help me with this.

       

      Thanks a lot

       

      Regards

      Thomas