Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Converting Local Currency to USD

tomtingley
8 - Asteroid

Hi,

 

I'm trying to convert my data from local currency into US Dollars using FX rates below

My FX rates are quarterly, so I would want Jan24, Feb24 and Mar24 to be converted using the Q1 FX Rate and Apr24, May24, Jun24 with the Q2 rate, etc.

 

Is anyone able to help?

The currency I am converting from is in the 'Currency Column'. For example, Property A is in ZAR and Property B is in CHF.

 

FX Rates per quarter

ZAR - 0.055, 0.055, 0.054, 0.053

GBP - 1.163, 1.162, 1.161, 1.049

CHF - 1.072, 1.078, 1.084, 1.090

3 REPLIES 3
ShankerV
17 - Castor

Hi @tomtingley 

 

One way of doing this.

 

ShankerV_0-1681375084123.png

 

 

Many thanks

Shanker V

ShankerV
17 - Castor

Hi @tomtingley 

 

Step 1: Input.

 

ShankerV_0-1681375139210.png

 

 

Step 2:

 

ShankerV_1-1681375157277.png

 

 

Step 3: 

 

ShankerV_2-1681375174943.png

 

ShankerV_3-1681375183587.png

 

Step 4: 

 

ShankerV_4-1681375196384.png

 

IF [Name] = "Jan - 2024" or [Name] = "Feb - 2024" or [Name]="Mar - 2024"
THEN 2
ELSEIF [Name] = "Apr - 2024" or [Name] = "May - 2024" or [Name]="Jun - 2024"
THEN 3
ELSEIF [Name] = "Jul - 2024" or [Name] = "Aug - 2024" or [Name]="Sep - 2024"
THEN 4
ELSE 5
ENDIF

 

ShankerV_5-1681375214094.png

 

Step 5:  Input of Fx

 

ShankerV_6-1681375237360.png

 

Step 6: 

 

ShankerV_7-1681375254613.png

ShankerV_8-1681375266118.png

 

Step 7:

ShankerV_9-1681375291087.png

 

ShankerV_10-1681375298770.png

 

Step 8:

ShankerV_11-1681375317093.png

ShankerV_12-1681375325005.png

 

Step 9:

 

ShankerV_13-1681375344239.png

 

ShankerV_14-1681375353459.png

 

 

Step 10:

ShankerV_15-1681375375770.png

 

ShankerV_16-1681375384703.png

ShankerV_17-1681375394307.png

 

Last step:

ShankerV_18-1681375414352.png

 

ShankerV_19-1681375422810.png

 

 

Many thanks

Shanker V

RobertOdera
13 - Pulsar

Hi, @tomtingley 

 

Kindly consider the below.

I hope you find it helpful - Cheers!

 

RobertOdera_0-1681392869718.png

 

Labels
Top Solution Authors