Add a field. If you do not want to specify a calculation, just specify the field name.
Dynamic calculations can be performed by specifying a calculation formula in the field name in the following format. In the following example, the calculation result of T000+T001 will be displayed.
[cal] formula
Example: [cal]T000+T001
Additionally, you can customize the calculation method by adding parameters after cal.
[cal:Parameters]
Example) [cal:uncertainiszero,qc_nultobad]T000+T001
The parameters that can be specified are as follows. If you want to specify multiple parameters, separate them with commas.
Parameters
|
Contents
|
uncertainiszero
|
Specify this if you want to perform calculations while treating undefined values as 0. If uncertainiszero is not specified, the calculation result will be NULL if a NULL value is present, regardless of the parameters below.
|
No qc_xxx specified
|
Do not perform quality check. For details about quality check, see "Use the quality check function".
|
qc_nulltonull
|
If a NULL value exists in the calculation data, it is treated as a NULL value.
|
qc_nulltobad
|
If a NULL value is present in the calculation data, it is treated as an unreliable value (such as *123).
|
qc_badtonull
|
If the calculation data contains unreliable values (such as *123), the value is treated as NULL.
|
qc_badtobad
|
If an unreliable value (such as *123) is present in the calculated data, it is treated as an unreliable value (such as *123).
|
If multiple conditions are specified, such as [cal:uncertainiszero,qc_nulltonull,qc_nulltobad], and both conditions are met (NULL records exist and there is also an untrusted value), qc_Xxxtonull will take precedence.
|
The uncertainzero parameter takes precedence in the quality check of dynamic calculations. If uncertainzero is not specified, the calculation result will be NULL if a NULL value exists, even if qc_nulltobad is set as above.
Example: When NULL values exist in the calculation data
Not defined: NULL+123=NULL
uncertainzero : NULL+123=123
uncertainiszero,qc_nulltonull : NULL+123=NULL
uncertainiszero,qc_nulltobad : NULL+123=*123
qc_nulltonull : NULL+123=NULL
qc_nulltobad : NULL+123=NULL
|
|
