CNTCURS

Counts occurrence of a condition in the cursor (e.g. pytype="3").

Reporting Area(s):

General

Required Parameters:

  1. Condition in cursor to count (i.e. "pytype='3' ")

Optional Parameters:

  1. field in cursor on which to group (i.e. "pyid")

Example(s):

CNTCURS("pytype='3'") returns number of billing records in cursor

CNTCURS("pytype='3'", "pyid") returns number of billing records in cursor grouped by pyid (i.e. only counts one billing record per pyid)

 

Related Topics Link IconRelated Topics