How can I add a O.ItemGroup filter to REPORT ORDER DETAILS

Its been requested that I combine item groups into single categories for servers so they can have a recommended tip based on sales that are produced out of the kitchen. When I apply an expression like O.ItemGroup!=Liquor, I don’t get any results. Here is what I’m trying to do:

[Category Sales Report:1,1,1]
>Kitchen|{REPORT ORDER DETAILS:O.ExactTotal.Percent.desc,O.ExactTotal.Sum:(ODI=True) AND (O.ItemGroup!=Beer) AND (O.ItemGroup!=Liquor) AND (TS.Status=Paid) AND (TEN.Server={SETTING:CURRENTUSER})}

Is O.ItemGroup a field tag?
If so it would not want brackets and value to be quoted.
Try think this;
AND O.ItemGroup!=“Beer” AND
I’d also maybe simplify to just one for now to test :wink:

Try using (MG!=Beer) && (MG!=Liquor)

1 Like

Thanks @JTRTech. I’ve had it simple and the problem was the ItemGroup. Looks like MG is the solution.

Thanks @Posflow.

MG=Breakfast did work, but the != didn’t work with MG. I found a post form earlier which showed != use with MenuItem.GroupCode: