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.
I wanted to create a formula using "less than" - so if ... = less than 0.0003 then "yes"
Anyone have any idea?!
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.
Here's an example formula:
IF [KDE] = "Probability of Default" AND [ZEUS] < 0.0003
as @Thableaus points out, the ZEUS variable should be a numeric (e.g. DOUBLE) data type.