## How to use a column property in a formula?

Community Trekker

Joined:

Jun 18, 2012

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Community Manager

Joined:

Jun 23, 2011

Solution

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
3 REPLIES

Super User

Joined:

Jun 23, 2011

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 );

Community Manager

Joined:

Jun 23, 2011

Solution

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

Community Trekker

Joined:

Jun 18, 2012

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!