Dear colleagues,
I have daily cash flows forecast in foreign currency (for treasury purposes) and monthly exchange rates forecast. An only I need for daily cash flows forecast in local currency is: convert monthly exchange rates into daily time scale, but it looks to be sophisticated formula. Thank you in advance for any ideas!
--
Module1: Exchange rates (only Time dimention and single line item)
Time Scale Exchange Rate
Jan18 60.0000
Feb18 65.0000
Module2: CF Forecast (only Time dimention and single line item)
Time Scale Exchange Rate
01 Jan 18 60.0000 to be displayed here
02 Jan 18
03 Jan 18
