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

    Dynamic Currency Conversion Calculated Field

    Thomas Kont



      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