Add a Where Clause Function Custom Field

Use a WHERE clause custom field to extract only those records that fulfill a specified condition.

To add a WHERE clause function to a Custom Field:

  1. Click Create New from the Custom Fields tab.
  2. In the Custom Field Builder dialog box click Type and select Function.
  3. In the Condition fields, select one of the following:
    • Average
    • Count
    • Count Distinct
    • Maximum
    • Minimum
  4. Complete the Format and Apply condition over fields accordingly.
  5. Type the name of the Custom Field in the Custom Field Name box.
  6. Click Add Where Clause to apply a WHERE clause. The following dialog box displays:

  7. Click the Select an option field and select the report field on which you want to add the WHERE clause from the drop-down menu.

    1. Select an operator from the drop-down menu:
      • equal
      • not equal
      • in
      • not in
      • begins with
      • doesn't begin with
      • contains
      • doesn't contain
      • ends with
      • doesn't end with
      • is empty
      • is not empty
      • is null
      • is not null
    2. Type the expression.
  8. Optionally, click one of the following:
    • Add Filter to add another field.
    • Add Group to add a group of filtered fields.

    Perform step 7 above to complete the fields.

  9. Save the Custom Field.

Note: Click Remove WHERE Clause to remove the WHERE clause from the Custom Field.