cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
mvanderaa1
Level IV

how to use table variables in column formula

Can someone tell me how I'm supposed to use table variables in the formula editor? Say I have a variable x with value 3, I open the editor and create a column with value 2*x. In the editor the preview nicely shows that this would return values of 6 for the entire column. However, after applying it this is not the actual result but I'm getting a Name unresolved error instead.

 

This is not intuitive at all. I have been able to get it to work in the past but every time I'm struggling again.

Additionally it would be nice to just have a list of the columns and table variables to pick from while in the formula editor.

 

mvanderaa1_0-1655123951748.png

 

mvanderaa1_1-1655124025862.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: how to use table variables in column formula

Maybe we are using different JMP version (I'm using JMP16.2) but I do see both column and table variable selection in formula editor

jthi_0-1655126055640.png

jthi_1-1655126071274.png

with your data

jthi_3-1655126180807.png

jthi_4-1655126194979.png

 

Using JMP > Create Formulas in JMP > Refer to Data Table Values in Formulas (jmp.com) 

-Jarmo

View solution in original post

3 REPLIES 3
jthi
Super User

Re: how to use table variables in column formula

Maybe we are using different JMP version (I'm using JMP16.2) but I do see both column and table variable selection in formula editor

jthi_0-1655126055640.png

jthi_1-1655126071274.png

with your data

jthi_3-1655126180807.png

jthi_4-1655126194979.png

 

Using JMP > Create Formulas in JMP > Refer to Data Table Values in Formulas (jmp.com) 

-Jarmo
mvanderaa1
Level IV

Re: how to use table variables in column formula

thanks for the reply, for some reason this panel was completely hidden for me. When I click on the table variable to create the formula it actually works.

jthi
Super User

Re: how to use table variables in column formula

To me it looks like it might be collapse. This is my window:

jthi_0-1655129992598.png

I can drag the line between functions and columns and it will hide column selection

jthi_1-1655130023926.png

but I can drag it back from the left line where column selection should be. You can also use red triangle next to formula selections and reset the panel layout

jthi_2-1655130169809.png

 

-Jarmo