community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Less than Formula

Meteor

less than.PNG

 

Hey!

 

I wanted to create a formula using "less than" - so if ... = less than 0.0003 then "yes"

 

Anyone have any idea?!

 

 

Alteryx Certified Partner

Hi @emiafshar 

 

IF [Field] < 0.0003 THEN..

 

Make sure your field is numeric.

 

If it isn't, use ToNumber([Field]).

 

Also, I noticed you "+" after a "=" in your condition.

 

If you want both conditions to be true, use AND operator.

 

 

Cheers,

Alteryx Certified Partner
Alteryx Certified Partner

Here's an example formula:

 

IF [KDE] = "Probability of Default"  AND [ZEUS] < 0.0003
THEN "YES"
ELSE "NO"
ENDIF

as @Thableaus points out, the ZEUS variable should be a numeric (e.g. DOUBLE) data type.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels