We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Another "vLookup" Question

daveyc3000
7 - Meteor
‎05-02-2024 07:43 PM

so in my "DATA" file, i have a currency column (column A); any row with "U$", the MV needs to be multiplied by the "Close" rate shown in the "FX" file ( that is, the rate shown in cell I10).

 

probably simple to do, but im a newb

Preview file
9 KB
Preview file
20 KB
Reply
0 Likes
10 REPLIES 10
daveyc3000
7 - Meteor
‎05-03-2024 08:37 AM

Sorry I dont understand when I tried to make the "C$" rate = 1 , Alteryx makes it 0????

 

screenshot.PNG

Currency Flow.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All