In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO 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.
SOLVED

IF Formula - Invalid Type In Operator

javerna
5 - Atom
‎11-25-2024 01:12 PM

Hi! Can anyone help me understand why I'm getting the following error with my formula below: "Invalid type in operator <"

 

IF [AYR] < [PriorPrior]
THEN -9999
ELSE [AYR]
ENDIF

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
alexnajm
19 - Altair
19 - Altair
‎11-25-2024 01:14 PM

You may be comparing a number or a string or vice versa - check your data types!

Reply
flying008
15 - Aurora
‎11-25-2024 04:17 PM

Hi, @javerna 

 

FYI.

 

IIF(ToNumber([AYR]) < ToNumber([PriorPrior]), -9999, [AYR])
Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All