formula To show only cash sales that have multiple return authorizations, you would need to add a formula field to the Criteria tab. This formula would need to count the number of return authorizations for each cash sale, and only include the cash sales where this count is greater than 1

AI generated answer (using internal Slack threads):

To create a saved search that shows only cash sales that have multiple return authorizations, you would need to add a formula field to the Criteria tab. This formula would need to count the number of return authorizations for each cash sale, and only include the cash sales where this count is greater than 1. Here's a general idea of how you might set up the formula: 1. In the Criteria tab, add a new line with the type "Formula (Numeric)". 2. In the Formula field, enter a formula similar to this:

CASE WHEN {returnauthorization.internalid} IS NULL THEN 0 ELSE 1 END

3. Set the Summary Type to "Sum". 4. In the same Criteria tab, add another line with the type "Formula (Numeric)". 5. In the Formula field, enter

1

. 6. Set the Summary Type to "Count". 7. Set the operator to "greater than" and the value to

1

. This formula will count the number of return authorizations linked to each cash sale. The search will then only include the cash sales where this count is greater than 1, which means it will only show cash sales that have multiple return authorizations. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******