Good day.  I am not understanding why the following formula works in my transaction saved search criteria:

(Formula Numeric) equals 1

CASE WHEN ({type} = ‘Item Receipt’ AND SUBSTR({appliedtotransaction},1,8) = ‘Transfer’) THEN 1 ELSE 0 END

But, when I do this, it only shows Cash sales and Invocies:

CASE

WHEN ({type} = ‘Item Receipt’ AND SUBSTR({appliedtotransaction},1,8) = ‘Transfer’) THEN 1

WHEN ({type} = ‘Invoice’ )THEN 1

WHEN ({type} = ‘Cash Sale’ )THEN 1

ELSE 0 END

This returns 900K rows.  When I sort by the type, it only shows Cash Sales and Invoices.  It doesn’t make sense that the Item receipt would no longer appear.  I don’t see any other filter that would prevent.

Any ideas?  Thanks!

M.