How to convert monthly exchange rates into daily time scale

CommunityMember96369
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 ACCEPTED SOLUTION

Accepted Solutions
PaulRitner
Valued Contributor

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

View solution in original post

1 REPLY 1
PaulRitner
Valued Contributor

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

View solution in original post