In a Transaction Saved Search, I want to return the Amount from the line where Class = 'Operator Commissioning' and Department contains 'Service', but only if another line in the same transaction has Class = 'Operator Sales' and Department contains 'Sales'.
Can this type of comparison logic be achieved directly in a Saved Search formula field using a CASE WHEN formula?