Community Trekker

Joined:

Jun 18, 2012

## 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?

1 ACCEPTED SOLUTION

Accepted Solutions

Community Manager

Joined:

Jun 23, 2011

Solution

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

Super User

Joined:

Jun 23, 2011

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

Community Manager

Joined:

Jun 23, 2011

Solution

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

Community Trekker

Joined:

Jun 18, 2012

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