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