Hello,
I am new to Alteryx and I am trying to do a calculation using If Then and returning a value from another column. I have stated with the From to Calculation but missing the portion to bring back the result once it does the calculation. In the sample attached, I am trying to look up the fruit price in a price in a range and return the percent from the result.
Solved! Go to Solution.
Hi @verde0903 ,
if I get you right, you want the percentage, if pricing on sheet 'Fruit' within the range on sheet 'Percentage'.
You can get this by joining the sheets and using a condition, but you'll need a filter to select the "match rows" only.
I've attached a sample workflow.
Let me know if it works for you.
Best,
Roland
Thank you Roland. The formula worked. It returned the result I needed. Thank you so much for your assistance.
Thank you lmadZidan for your query. This is a formula I can utilize in other workflows I am creating. For this query it needed the if/then which Roland assisted with. Thanks for your assistasnce.