XOR

(This section relates to users with an Enterprise Licence only)

Use the XOR operator in a formula when you want to compare values by specifying mutually exclusive conditions, i.e. A or B may be TRUE but not both A and B.

To use the XOR operator:

Syntax:

Part	Description
Field	Required. The name of the field in the database that contains the value you want to compare.
Value	Required. A value you want to test in the formula. This can be a literal value or date.
Operator	Required. This must be the equals to (=) operator.

In the Formula pane, from the row of Operator buttons, click the XOR button. The appropriate brackets are automatically entered, ready for you to construct your formula:

()XOR()

Construct the XOR formula using the tools provided to add the required parts; Field and Value. For example, if you wanted to test for an open date of either 1st June 2012 or 1st July 2012, but not both, the formula should look like this:

(OpenDate=01/06/2012)XOR(OpenDate=01/07/2012)

(Recommended) Test the formula against a matter to make sure it produces the expected result. To do this, type a matter number in Entity Ref/ID and click Test Formula.

Notes

This operator only works with formulas of type Logical.
Before adding parts to a formula you must click the insertion point to set focus.
When testing, if the result is not as expected then amend the formula and retest.