cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
ks_SES
Level III

column values dependent on another column

Hi, I have two columns, and I hope the values of column 2 will depend on column 1 through a kind of Boolean control.

For example, I need the column 2 below to be automatically filled:

if Column 1>0, then Column 2 in the same row becomes filled with 3.

if Column 1<0, then Column 2 in the same row becomes filled with 0. 

 

 Capture.PNG

Thanks a lot! 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: column values dependent on another column

You can use a formula in Column 2 based on this expression:

 

If( :Column 1 > 0, 3, 0 )

You can copy it here, open the Formula Editor for Column 2, and paste it.

View solution in original post

2 REPLIES 2

Re: column values dependent on another column

You can use a formula in Column 2 based on this expression:

 

If( :Column 1 > 0, 3, 0 )

You can copy it here, open the Formula Editor for Column 2, and paste it.

ks_SES
Level III

Re: column values dependent on another column

Thanks! It works.