Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Help Fixing Formula

Khristian_Evans
8 - Asteroid

IF [price] = '49.49' THEN "MONTOURBASE"+[transaction_begin_date] ELSE "MONTOURTHIRD" + [transaction_begin_date] ENDIF

3 REPLIES 3
davidskaife
14 - Magnetar

What's the error you're getting?

Khristian_Evans
8 - Asteroid

Invalid Type in operator ==.

binu_acs
21 - Polaris

@Khristian_Evans check your data type of the field [price], as per your formula, it should be a string Datatype , if it is not string data type either change the datatype to string or update the formula IF [price] = 49.49 THEN "MONTOURBASE"+[transaction_begin_date] ELSE "MONTOURTHIRD" + [transaction_begin_date] ENDIF

Labels
Top Solution Authors