Formula (conditional statement) - Trying to recreate a SQL case statement

jmorris14

Hello,

I am new to Alteryx. I am trying to recreate a formula that I built in SQL within Alteryx and it is proving to be quite difficult. Here is what I have built;

IF [Contract_Status]= "Accepted"

AND [product_id]= 153 OR [product_id]=155 OR [product_id]=157
AND [date_paid]>=2017-08-01 AND [date_paid]<=2017-12-31
THEN "Non-Renewal"
ELSE "Other"
ENDIF

When I run it I get the error "The field " " is not contained in the record. (Expression #1)"

Essentially what I am trying to say is if contract_status=accepted AND if product_id CONTAINS either  153 or 155 or 157 AND the date_paid falls in that range then call is "Non-Renewal"

What do I need to do differently?

Formula Question 1.PNG

danrh

All you need to do is give your field a name.  Click on the "Select Column" dropdown, select "+ Add Column" and type in the name of the calculated field.  This should take care of your error for you.

On a side note, I'd advise changing the or's to an in statement or wrapping them with parentheses to make sure the logic is what you're intending.

Welcome to Alteryx!