Q: How to use the setted spec limit/Target in formular?

Chily — Thu, 30 Nov 2023 03:59:07 GMT

Hi,

I am wondering how to use the setted spect limit data (Target) in formular?

For example(attach file):

The Column "NPN1" already setted USL/LSL/Target, and I would like to calculate (NPN1-Target) in the new column "shift"

How can I directly use (NPN1-Target) in formular instead of use (NPN1-118.15)? Thanks.

Regards,Chily

Re: Q: How to use the setted spec limit/Target in formular?

txnelson — Thu, 30 Nov 2023 05:02:30 GMT

Here is one way to write the formula

As Constant( target = (:NPN1 << get property( "spec limits" ))["Target"] );
:NPN1 - Target;