INSTANCE_COUNT
Description
INSTANCE_COUNT
is a row function that returns the total number of instance
values in a Multi-Instance or Instance field. This function returns 0 when the field
is empty.Syntax
INSTANCE_COUNT
(field_name
)Return Value
Returns one value per row of type Integer.
Input Parameters
- field_name
- Required. A field of type Multi-Instance or Instance.
Examples
Count the number of instance values in the
Journal Lines
Multi-Instance field:INSTANCE_COUNT([Journal Lines])