Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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...
COUNT({*< Product_Movex_Part_Number={'170203-00'},Product_Movex_Part_Number={'170700-00'}>*}SVMXC_Site_Id_Key) Never pastes correctly for me here.
COUNT({*< Product_Movex_Part_Number={'170203-00'},Product_Movex_Part_Number={'170700-00'}>*}SVMXC_Site_Id_Key)
COUNT({*< Product_Movex_Part_Number={170203-00,170700-00}>*}SVMXC_Site_Id_Key)
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
Thank you, that was it.