This OR This AND That OR That

[Anonymous]

Puzzled.  I want to see a locations that have  part "a"OR part "b", AND also have part "c" OR part "d" This does not seem to work.  I thought it would return when site had either 170200-00 OR 170203-00 AND also had either 170700-00 OR 170698-00.  I know it works with the a single OR on either side - just not when OR on both sides. COUNT({*< Product_Movex_Part_Number={'170203-00'}, Product_Movex_Part_Number={'170700-00'}>*}SVMXC_Site_Id_Key)

[Peter_Cammaert]

I know it can be done with an AND-field listbox and some grouping of products. But I do not know if this is possible with set analysis. Set analysis returns records that comply with the set specifications, and I guess a single record will never contain two products at the same time...

[Anonymous]

COUNT({*< Product_Movex_Part_Number={'170203-00'},Product_Movex_Part_Number={'170700-00'}>*}SVMXC_Site_Id_Key) Never pastes correctly for me here. 

[Anonymous]

COUNT({*< Product_Movex_Part_Number={'170203-00'},Product_Movex_Part_Number={'170700-00'}>*}SVMXC_Site_Id_Key)

[#5]

COUNT({*< Product_Movex_Part_Number={170203-00,170700-00}>*}SVMXC_Site_Id_Key)

[jonathandienst · Accepted solution]

Hi

Use an intersection for the AND part, like this:

COUNT({<Product_Movex_Part_Number={'170200-00', '170203-00'}>*<Product_Movex_Part_Number={'170700-00', '170698-00''}>} SVMXC_Site_Id_Key)

HTH

Jonathan

[Anonymous]

Thank you, that was it.