Multiple Operands

You can add multiple operands to an exclude constraint by clicking the Compound Field button when you create the constraint.

For example, you could create the constraint:

Item A excludes Item B > 2, Item C < 5

This constraint means the following:

• If Item A is present in the solution, Item B cannot be greater than 2

• If item A is present in the solution, Item C cannot be less than 5

• If Item B is greater than 2 in the solution, Item A cannot be present

• If item C is less than 5 in the solution, Item A cannot be present

Using commas to separate expressions is the same as writing two constraints:

Item A excludes Item B > 2

Item A excludes Item C < 5

If you want to write a constraint where you exclude the combination of two conditions you would do it as follows:

Item A excludes (Item B > 2 AND Item C < 5)

This constraint means that if Item A is present in the solution, the two conditions cannot be simultaneously true in the same solution. If Item A is present, the quantity of Item B can be greater than 2 as long as the quantity of Item C is not less than 5 and conversely.