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
Solved! Go to Solution.
Hi,
Use the MONTHVALUE function.
In the Day formatted module, the formula might be MONTHVALUE(Exchange Rates.Rate)
Cheers!
Paul