How to convert monthly exchange rates into daily time scale

[CommunityMember96369]

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  

[PaulRitner · Accepted solution]

Hi, 

Use the MONTHVALUE function.

In the Day formatted module, the formula might be MONTHVALUE(Exchange Rates.Rate)

Cheers!

Paul