Hi all! I'm looking for a little bit of help on compiling a search for open sales orders to show open orders that have items with a line level class value of 1. I also want to include lines with class value of 2 but only if the order has lines open for 1 was well.
i was thinking a formula with a case when statement for class value 1 and 2 but it shows orders that only have class value of 1 and class value of 2 instead of showing 1 only if the class value 1 is also included.