SetCalcExclude
Description:
Excludes the specified Data Items from a Calculation.
Input Properties
sdcid
Description:
Identifier of the SDC.
Required:
Yes
keyid1
Description:
Identifiers of the SDIs.
Required:
Yes
keyid2
Description:
Identifiers of the SDIs.
Required:
Only for multi-key SDCs.
keyid3
Description:
Identifiers of the SDIs.
Required:
Only for multi-key SDCs.
paramlistid
Description:
Identifiers of the Parameter List relevant to the Data Set associated with the SDI.
Required:
Yes
paramlistversionid
Description:
Parameter List Versions relevant to the Parameter Lists.
Required:
Yes
variantid
Description:
Parameter List Variants relevant to the Parameter Lists.
Required:
Yes
dataset
Description:
Data Set Numbers.
Required:
Yes
paramid
Description:
Identifiers of the Parameters.
Required:
Yes
paramtype
Description:
Identifiers of the Parameter Types associated with the Parameters.
Required:
Yes
replicateid
Description:
Replicate numbers of the Parameters.
Required:
Yes
excludeflag
Description:
Determines whether or not to exclude Data Items:
Y = Excludes the Data Item from the Calculation (default).
N = Includes the Data Item in the Calculation.
Required:
No
Additional Information
Additional information concerning this Action:
You can pass a fully-qualified Data Item into this Action (sdcid, keyid1, keyid2, keyid3, paramlistid, paramlistversionid, variantid, paramid, paramtype, replicateid).

Alternatively, you can pass a portion of the Data Item definition. For example:
sdcid=Sample, keyid1=S001 - Excludes all Data Items for Sample S001.
sdcid=Sample, keyid1=S001, paramtype=Standard - Excludes all "Standard" Data Items for Sample S001.
sdcid=Sample, keyid1=S001, paramtype=Standard, replicateid=2 - Excludes the second Replicate for "Standard" Data Items for Sample S001.

Excluded Data Items will no longer be visible to the Calculation routines. This may be used, for example, to omit certain outliers for a list of replicates to be averaged.

Excluded Data Items can be "unexcluded" using the same Action.

Excluding one or more Data Items in a Sample will force ALL Calculations in that Sample to be reevaluated, cutting an additional audit record for each calculated parameter.

Copyright © 1999-2016 LABVANTAGE Solutions, Inc.