I have a list I have compiled of items that we want to put on clearance. However it is pulling in the items that are already in our clearance report group. How can I remove all the items that have CLR as the report group from the Gridview?

This is the current code:

OR(
FIND ("P", {Picking Seq},1) > 0,
FIND ("Q", {Picking Seq},1) > 0,
FIND ("T", {Picking Seq},1) > 0,
FIND ("Z", {Picking Seq},1) > 0,
FIND ("CLR", {Comments 2},1) > 0,

AND(
{Qty On Hand} > 0,
{Qty on PO} = 0,
{Last Rcpt Date} < DATE(2011,04,01),
FIND ("TDL", {Comments 2},1) = 0
))


Thanks,
Lance

Add:

AND(
TRIM({Report Group})<>"CLR",
{Qty On Hand} > 0,
{Qty on PO} = 0,

to the AND() section.