FX Conversion

[tomtingley]

Hi,

I'm looking to create exactly the same format of the 'Local CCY' tab, but convert that data to USD using the rates from the 'FX Rates' tab.

The rates are split only by yearly averages, so for all months Jan-Dec 22, I would want to use the corresponding 2022 Average FX Rate.

As an example, Jan22 has 1,803 GBP Electricity. Therefore, using the 2022 GBP Annual Average Rate (1.231933333), this would become:

1803 * 1.231933333 = 2,221.2

Thanks,

Tom

[ShankerV]

Hi @tomtingley 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @tomtingley 

Step 1: Input the data.

Step 2:

Step 3:

Step 4:

Step 5: 

Step 6:

Step 7:

tonumber([Value])*[Right_Value]

 Last step: 

Many thanks

Shanker V