Skip to main content

Solutions

Law firms

Tax, audit & accounting firms

Corporations

Governments

Products

Legal

Trade & supply

Tax, audit & accounting

Corporate tax

Risk & fraud

Books

Recommended products

Questions? We are here to help.
Contact us

Purchase

Buy solutions

Buy books

Contact sales

Questions? We are here to help.

Resources

Insights

Events

Product training

Product communities

Developers

Arithmetic Functions

Minus Operator

- Operator

Description 1 of 5 (arithmetic subtraction):
Subtract a second number from a first number.
note
ARITHMETIC OVERFLOW
This function is non-evaluable if the resultant value would exceed approximately +/- 1.8e308.
For example, subtracting a very big positive number from a very big negative number.
Returns:
Number
Parameters:
Parameter
Data Type
Description
1
Number
The first value.
2
Number
The second value.
Examples:
When using functions inside a field, remember the field brackets:
{BaseRate - 1}
Expression
Result
2.5 - 3.4999
-0.9999
2 - 3.4999
-1.4999
2.4999 - 3.4999
-1
Description 2 of 5 (arithmetic negation):
Negate a number by subtracting it from zero.
Returns:
Number
Parameter:
Parameter
Data Type
Description
1
Number
The value.
Example:
Expression
Result
- ( 2.5 + 3.4999 )
-5.9999
Description 3 of 5 (the date which is a number of days before a date):
This is equivalent to the function
DaysBefore
, and is the date which is so many whole days before the source date.
If the number of days is positive then the resultant date will be before the source date.
If the number of days is negative then the resultant date will be after the source date.
Returns:
Date
Parameters:
Parameter
Data Type
Description
1
Date
The source date.
2
Whole Number
The number of whole days before.
Example:
Expression
Result
Date( 2000, 2, 29 ) - 60
Date( 1999, 12, 31 )
Description 4 of 5 (the difference between two lists):
This is equivalent to the function
Difference
, and returns those members of the source list which are not members of the removal list.
Note that the order of members of the source list is preserved.
Returns:
Any*
Parameters:
Parameter
Data Type
Description
1
Any*
The source list.
2
Any*
The removal list.
Examples:
Expression
Result
List("a","b","c","d") - List("b","d")
List("a","c")
List("a","b","c","d") - List("b","d","x","y")
List("a","c")
List("a","b","c","d","d","d") - List("b","d")
List("a","c")
Description 5 of 5 (the time which is a number of seconds before a time):
This is equivalent to the function
SecondsBefore
.
The time which is so many whole seconds before the source time.
If the number of seconds is positive then the resultant time will be before the source time.
If the number of seconds is negative then the resultant time will be after the source time.
Returns:
Time
Parameters:
Parameter
Data Type
Description
1
Time
The source time.
2
Whole Number
The number of whole seconds before.
Example:
Expression
Result
Time(12,0,0) - 61
Time(11,58,59)

This article applies to:

  • Product: Contract Express

Related Content