How to convert monthly exchange rates into daily time scale

Highlighted
Contributor

How to convert monthly exchange rates into daily time scale

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  

1 REPLY 1
Highlighted
Certified Master Anaplanner

Re: How to convert monthly exchange rates into daily time scale

Hi, 

 

Use the MONTHVALUE function.

 

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

 

Cheers!

 

Paul