SOLVED
FX Conversion
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
tomtingley
8 - Asteroid
‎05-09-2023
03:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
2 REPLIES 2
ShankerV
17 - Castor
‎05-09-2023
03:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ShankerV
17 - Castor
‎05-09-2023
03:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
