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

Alteryx designer Discussions

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

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
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