cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
plfazeli
Level II

OR formula

Hey can someone see if you can tell what's wrong with this formula? I want to stay that if any of these column names contains a value that is "EFV" then return the value of 1 for each row into the new column. 

1 REPLY 1
jthi
Super User

Re: OR formula

You have to compare them one by one. Or you can utilize Contains with a list

Contains(Eval List({:Column 1, :Column 2, :Column 3}), "a") > 0

jthi_1-1721995019918.png

 

jthi_0-1721995002502.png

 

There are also other methods

-Jarmo