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