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?


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



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?

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]


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