Hello, We are starting to use the WMS process and we are in the middle of transitioning so we are starting to create wave searches. We have a few kits that we sell and kits do not show up, so we would like to not show these orders. My wave criteria is attached. I'm using the over partition my boss provided to roll up the Kit/Package item types to be able to count them. It works in the results, but not when I add to the criteria. Here is the formula: CASE WHEN (sum/* comment */((CASE WHEN {item.type} IN ('Kit/Package') THEN 1 ELSE 0 END))OVER(PARTITION BY {internalid})) > 0 THEN 1 ELSE 0 END I only read one person stating that they were able to do it by transforming to character and then trimming it. I tried this with the following formula: TRIM(TO_CHAR((CASE WHEN (sum/* comment */((CASE WHEN {item.type} IN ('Kit/Package') THEN 1 ELSE 0 END)) OVER(PARTITION BY {internalid} ORDER BY TO_CHAR({internalid}, '00000000000009') DESC)) > 0 THEN 1 ELSE 0 END), '999999999')) This also did not work. I was wondering if there was a way to trick NetSuite to be able to use over partition in the criteria. Any help would be apricated, thank you.