@jcribb Use Case - I want to exclude ~50 of ~800 Bins from Inventory Totals - as they are considered unsellable (achieving a Total On Hand in one column, and a Total Sellable in another) . I can accomplish this using: case when {inventorynumberbinonhand.binnumber} NOT IN ('1-Returns','2-Returns','3-Returns) then {inventorynumberbinonhand.inventorynumber} end
However, it would be more efficient if I could simply exclude {inventorynumberbinonhand.binnumber} containing 'Returns'.