How to use a column property in a formula?

[#1]

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!

[#2]

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

[#3 · Accepted 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

[#4]

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!