156
Chapter 8
Function Result Description
@GLOBAL_MIN(FIELD) Number
Returns the minimum value for FIELD over the whole
data set, as previously generated by a Set Globals node.
FIELD must be the name of a numeric field. If the
corresponding global value has not been set, an error
occurs.
@GLOBAL_SDEV(FIELD) Number
Returns the standard deviation of values for FIELD over
the whole data set, as previously generated by a Set
Globals node. FIELD must be the name of a numeric
field. If the corresponding global value has not been set,
an error occurs.
@GLOBAL_MEAN(FIELD) Number
Returns the mean average of values for FIELD over the
whole data set, as previously generated by a Set Globals
node. FIELD must be the name of a numeric field. If
thec orresponding global value has not been set, an error
occurs.
@GLOBAL_SUM(FIELD) Number
Returns the sum of values for FIELD over the whole
data set, as previously generated by a Set Globals node.
FIELD must be the name of a numeric field. If the
corresponding global value has not been set, an error
occurs.
Functions Handling Blanks and Null ValuesUsing CLEM, you can specify that certain values in a field are to be regarded as “blanks,” or
missing values. The following func tions work with blanks.
Note: @ functions cannot be called from scri pts.
Function Result Description
@BLANK(FIELD) Boolean
Returns true for all records whose values are blank
according to the blank-handling rules set in an
upstream Typenode or source node (Types tab).
Notethat this function cannot b e called from a script.
@LAST_NON_BLANK(FIELD) Any
Returnsth e last value for FIELD that was not blank,
as defined in an upstream source or Type node.
If there are no nonblank values for FIELD in the
records read so far, $null$ is returned. Note that
blankvalues, alsocalled user-missing values, can be
defined separately for each field.
@NULL(FIELD) Boolean
Returns true if the value of FIELD is the
system-missing $null$. Returns false for all other
values, including user-defined blanks. If you
want to check for both, use @BLANK(FIELD)and
@NULL(FIELD).
undef Any
Usedgenerally in CLEM to enter a $null$ value—for
example, to fill blank values with nulls in the Filler
node.