Or Group logic tables

To create an And and Or condition between attributes, you can use the Or Group field on List (MX10.1). You can use this field to identify whether the attributes are grouped or treated individually. If you leave this field blank, the And condition is used by default which connects two statements with an And or an Or condition. If you specify an Or condition, you can specify any alphanumeric character in the field.

You can include combinations of And and Or conditions. You can use And conditions to link value ranges together as one condition. For example, if you select customers based in California and have balances of 50,000 or greater, then you can use Or conditions to establish multiple sets of criteria that are applied separately. For example, if you select customers who that have credit analyst Johnson or Smith.

If you have multiple conditions in a list, you can specify an Or condition in the Or Group field to separate the conditions. Selection criteria above or below an Or condition are applied separately.

This table shows how you can combine attribute and Or group combinations to create conditional statements:

If the Attribute on the preceding or subsequent line is	And the Or Group on the preceding or subsequent line is	Result
EQUAL	EQUAL	Not valid
EQUAL	NOT EQUAL	Or condition
NOT EQUAL	EQUAL	And condition
NOT EQUAL	NOT EQUAL	Or condition

This table shows an example of attributes and Or groups you can combine to include all California-based customers who have credit analyst Smith or with balances of 50,000 or more:

Attribute	Value Range	Or Group	Result	Notes
STATE	CA CA	1
CR ANALYST	SMITH SMITH	2	And	Attributes = Not Equal Or Group = Equal
STATE	CA CA	2	Or	Attributes = Not Equal Or Group = Not Equal
STATIC AGING 4	50,000 50,000	1	And	Attributes = Not Equal Or Group = Equal