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) |