Ever have one of those days where you brain just d...
# general
r
Ever have one of those days where you brain just doesn't cooperate and you can't remember even the simplest stuff? Today is one of those days. I need to create a saved search for sales order transactions that contain only two specific SKUs. The part I'm stuck on is that the orders should only have one of the two SKUs on it, any result should filter out any other orders with other items on it. Was wondering the best way of accomplishing this. Thanks.
b
This wouldnt be something simple
this sounds like you would need a Summary Search Filter
l
all day long every day
k
I mean, summary search filters are pretty simple. that said Summary criteria (formula numeric) (type of sum) (goal of 1)
case  {item} when 'X' then 1 when 'y' then 1 else 0 end
That will get you the desired result with a little tweaking.