community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Using Conditional IF THEN ELSE Statement to +1 or -1 to another number

Hello, 

 

I am wondering if it is possible to use conditional statements to add or subtract 1 to a set of values based off of another set of values. E.g. I have created a check figure row in Alteryx that either shows -1, +1, or 0 on a number of items. For items with the check figure -1 I need it add 1 to another set of values, for items with +1 I need it to subtract 1 from that set of values, and if 0 to simply be the number from that list of values. Is this possible?

Highlighted
Alteryx Certified Partner

Hi @Michaelovermyer 

 

Yes, totally

 

EDIT: You don't need an IF/ELSE Statement

 

something like that I think it would work:

 

[Set of Values] - [Figure]


Cheers,

Worked perfectly, I was making it too complicated myself, thanks for the help!!

Labels