This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
What are KDE and Merival? If they are data points from earlier in the workflow, then they need to be in brackets. Also, are the pluses supposed to be "and" ? If so, change it to "and". The plus is a concatenator for strings (or sum for numbers).
With 2 posts for the same question, there's lots of potential solutions for you. As suggested, you should check the variable data type so that you use appropriate values in your formula.
"Mark" < 100 is False. Not because my age is really greater than 100, but because numbers sort before letters when comparing them alphabetically. When putting an argument in quotes, you're looking at a string. Alteryx uses the convention of placing field names inside of square brackets. You MUST use the convention if the field name has a space inside of it or if the field name is entirely numeric.
What is a number? If you can perform math on the value, I'd store it as a number. If the data is entirely numeric (e.g. Phone, ZIP, Grade in School) it isn't necessary to store it with a numeric data type. Sure it saves space, but it really isn't a number. For your formula, you can temporarily convert a value (e.g. 0.0003) from a string to a number by use of the ToNumber() function. But as a practice, I'd use a select and change the data type instead.
I hope that you have solved the challenge. I'd also suggest using the interactive training as (from my memory) it covers some data type lessons.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.