Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference COUNT
Functions and Expressions Reference Guide
77
COUNT
The COUNT function returns an integer representing the number of valid input
objects in a series.
Syntax
COUNT (series-object-expression)
Meaning
COUNT (valid_objects_to_count)
Returns
This function returns a single-integer.
The result is the number of valid_objects_to_count. If the input argument
evaluates to NONE,
COUNT returns 0.
Note COUNT does not count existing NONEs unless its group was defined as an
explicit format with a Track setting of Places.
Examples
COUNT ( Claim Record:Patient File )
This example returns the number of valid Claim Record objects in Patient
File.
COUNT ( Class IN Transcript )
This example returns the number of valid Class objects in Transcript.
COUNT ( UNIQUE ( Class IN Transcript ) )
This example returns the number of valid Unique Class objects in Transcript.
Uses
Use
COUNT to count the valid input or output objects in a series.
Related Functions
COUNTABS