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
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!