If Then calculation and return value.

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.

Data Investigation

Accepted answers

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

IfThenCalculation.yxzp

All comments

Hello,

I don't think the formula will accommodate what you require. See workflow and it will give you an idea.

I hope this helps.

Dynamic Fields Names.yxmd

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

IfThenCalculation.yxzp

oops I attached the wrong workflow.

Here you go.

Fruit Pricing Percent.yxmd

Thank you Roland. The formula worked. It returned the result I needed. Thank you so much for your assistance.

Quick Links

Tags

This months top contributors

Hollingsworth 335