Subtract

This section relates to users with an Enterprise Licence only.

se the minus sign (-) operator in a formula when you want to subtract numbers. The numbers can be derived from database fields or you can enter literal values.

To subtract numbers:

Syntax:

This syntax has these parts:

Part	Description
Value	Required. The numbers that are to be subtracted. This can be a literal value or the name of a field in the database that contains a numeric value.

CurrentDate-OpenDate

In the Formula pane, from the row of Operator buttons, click the - button. You can also use the Minus key on your keyboard. A minus sign (-) is automatically entered, ready for you to construct your formula:
Construct the formula using the tools provided to add the required parts; NumberValue. For example, if you wanted to work out the number of days a matter has been open, the formula might look like this:
(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 Number and Date.
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.