You can compare output fields of the same data type. For example, you can create a query that selects constituents whose Last Gift Amount equals their Largest Gift Amount.
To do this, add the Last Gift Amount and Largest Gift Amount smart fields under Result fields to display, and add the Last Gift Amount field under Include records where. On the criteria screen, select the criteria operator, such as “Equal to”. Select Output Field and then select the Largest Gift Amount field. When you return to the query, “Last Gift Amount is equal to Largest Gift Amount” appears under Include records where.
Note: For information about how to add smart fields, see the Administration Guide.
On the Sort/Group Filters tab, you can compare COUNT, SUM, AVG, MIN, or MAX values of filter fields. For example, you can compare the SUM of planned gifts payments to the SUM of pledge payments.