Extraction types

The extraction types that are available depend on whether the query is a summary or a detail query.

These are all the extraction types:

• Sum: Returns the sum of the values in a group.
• Count: Returns the number of items in a group.
• Average: Returns the average of the values in a group.
• Minimum: Returns the minimum value from a group of values.
• Maximum: Returns the maximum value from a group of values.
• Distinct Sum: Returns the sum of only the unique values in a group.
• Distinct Count: Returns the number of unique values in a group.
• Distinct Average: Returns the average of the unique values in a group.
• Segment: Returns part of a string, specified by offset and length.

  See: Segment extraction format.

• Code: Returns the code of an item. For example, C for credit items.
• Description: Returns the description of an item code. For example, Credit or Debit.
• Short Description: Returns the short description of an item code. For example, Cr or Dr.

Many extraction types have options to reverse the sign notation for positive and negative values.

See: Using reverse sign notation.

Many numeric extraction types have options to specify scaling.

See: Using scaling.