cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
markschahl
Level V

How to use a column property in a formula?

I've assigned the Column Property: Spec Limits; Target to some columns. I need to create a pass/fail formula that checks if the value is >= 25% of that column's Target value. Can the formula editor access the Target property? If not, what is the best way to script use of the column Target in a formula?

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

Re: How to use a column property in a formula?

You can get column properties in a column formula.

 

mpb showed the syntax. Here's what it would look like in a formula:

 

(:Weight << get property( "Spec Limits" ))["LSL"]

 

The parentheses are important as you need to make sure the "LSL" subscript is on the result of the Get Property message.

 

I've attached a data table showing this formula.

 

-Jeff

-Jeff

View solution in original post

3 REPLIES 3
mpb
mpb
Level VII

Re: How to use a column property in a formula?

Here's an example assuming the fitness data is the active table. Use the Column Info dialog to put your own spec limits in for, say, the oxy column. For testing I set the LSL, Target, USL as 40, 50, 60 respectively. Open the log window to see that the spec info was read correctly.

 

 

dt1 = Data Table( "Fitness" );
specs = Column( dt1, "Oxy" ) << get property( "Spec Limits" );
lsl = specs["LSL"];
usl = specs["USL"];
target = specs["Target"];

 

Show( lsl, usl, target );

Jeff_Perkinson
Community Manager Community Manager

Re: How to use a column property in a formula?

You can get column properties in a column formula.

 

mpb showed the syntax. Here's what it would look like in a formula:

 

(:Weight << get property( "Spec Limits" ))["LSL"]

 

The parentheses are important as you need to make sure the "LSL" subscript is on the result of the Get Property message.

 

I've attached a data table showing this formula.

 

-Jeff

-Jeff
markschahl
Level V

Re: How to use a column property in a formula?

Thanks Jeff. Was exactly what I was looking for: avoiding to having to script (not that scripting is bad, but formula editor is easier). I will use this a lot!