Count

To retrieve a count of occurrences of a data item in the database, use the count aggregate function in the Query section.

  1. In Query section, double click the intended item on the Request Line (or select item and select Modify).
  2. Press the Functions… button on right in dialog box.
  3. Select Aggregate Functions from the Function List Categories window in the Database Functions dialog box.
  4. Select Count from the Functions available in the window to the right.
  5. Click OK in the Database Functions dialog box.
  6. Click OK in the Item dialog box.
  7. To review/modify the computed item double click on the item name on the Request Line.

Last updated: October 15, 2013

Last updated: October 15, 2013