topic Re: How to use a column property in a formula? in Discussions

How to use a column property in a formula?

markschahl — Fri, 07 Nov 2014 18:28:11 GMT

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?

mpb — Wed, 03 Apr 2019 17:54:11 GMT

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

Re: How to use a column property in a formula?

Jeff_Perkinson — Wed, 03 Apr 2019 17:53:46 GMT

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?

markschahl — Mon, 10 Nov 2014 19:22:25 GMT

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!