Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
community Alteryx Academy MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎05-14-2025 07:48 AM

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

Labels:
Reply
0 Likes
3 REPLIES 3
davidskaife
14 - Magnetar
‎05-14-2025 08:14 AM

What's the error you're getting?

Reply
0 Likes
Khristian_Evans
8 - Asteroid
‎05-14-2025 08:41 AM

Invalid Type in operator ==.

Reply
0 Likes
binu_acs
21 - Polaris
‎05-14-2025 09:08 AM

@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

Reply
0 Likes
Labels
Top Solution Authors
View All