BookmarkSubscribeRSS Feed
markschahl

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?

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson

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
mpb

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

Jeff_Perkinson

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
markschahl

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!