If statement

[angelique_martin]

Hi Alteryx Community,

I am trying to determine how to write this if statement to create a new column within Alteryx:

If there is one row for an agreement number and condition type =Y909 and scale_qty is null  then "growth Flat%". Also if there is one row for an agreement number and condition type =Y909 or Y917 then "Growth-Threshold". Please see below pictures of what I have versus what I want. Thank you in advance!

Current Outcome:

Desired Outcome:

[chukleswk · Accepted solution]

You can use the following if formula using the attached flow. This produces the desired output but does not take into account if you have more than one Agreement_Num or if there is a Cond_Type other than Y909 or Y917.