Hi, is there a way to create a saved search that returns rows based on a result of an aggregation? For example, getting the customers whose invoices are collectively over 1K.

Thanks. I tried this but it doesn't work as I expected, I think I am missing something. This may be a weird test, but it should work. I chose an invoice, and set the sum criteria to be over the amount of the invoice... this should return nothing, but it returns four lines.

You need to group by something in the results

Oh, ok, let me try that

Also if your criteria doesn't have Main Line = T then SUM(Amount (Transaction Total)) will give you Transaction Total * Number of Lines

Aha, because I am not choosing the rate, it is the same total on each line.