Inverse Function
Description 1 of 6 (the inverse of a number value):
The negative value of a number (same as unary minus).
Returns:
Number
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Number | The number value. |
Example:
When using functions inside a field, remember the field brackets:
{Inverse(VariableName)}
Expression | Result |
|---|---|
Inverse( -3.5 ) | 3.5 |
Inverse( Inverse( -3.5 ) ) | -3.5 |
Description 2 of 6 (the inverse of a boolean value):
The negation of a boolean (same as Not).
Returns:
Boolean
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Boolean | The boolean value. |
Examples:
Expression | Result |
|---|---|
Inverse( true ) | false |
Inverse( false ) | true |
Inverse( Inverse( true ) ) | true |
Description 3 of 6 (the inverse of a text value):
The inverse of each character in the text.
A character is inverted by subtracting its UNICODE number from 65536.
Returns:
Text
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Text | The text. |
Example:
Expression | Result |
|---|---|
Inverse( "abc" ) | "ﾟﾞﾝ" |
Inverse( Char( 65536 - Code( "A" ) ) ) | "A" |
Inverse( Inverse( "A" ) ) | "A" |
Description 4 of 6 (the inverse of a date value):
The inverse date which is calculated relative to an imaginary minimum date of 1600-1-1 and an imaginary maximum date of 3999-12-31.
Returns:
Date
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Date | The date value. |
Examples:
Expression | Result |
|---|---|
Inverse( Date(1600,1,1) ) | Date(3999,12,31) |
Inverse( Date(3999,12,31) ) | Date(1600,1,1) |
Inverse( Inverse( Date(2000,2,29) ) ) | Date(2000,2,29) |
Description 5 of 6 (the inverse of a time value):
The time 23:59:59 minus the given time.
Returns:
Time
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Time | The time value. |
Examples:
Expression | Result |
|---|---|
Inverse( Time(0,0,0) ) | Time(23,59,59) |
Inverse( Time(12,0,0) ) | Time(11,59,59) |
Inverse( Inverse( Time(15,30,45) ) ) | Time(15,30,45) |
Description 6 of 6 (the inverse of a list of values):
The list whose members are the inverse of each member of the given list.
Returns:
Any*
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Any* | The list. |
Examples:
Expression | Result |
|---|---|
Inverse( List( 1, 2, 3 ) ) | List( -1, -2, -3 ) |
Inverse( List( Time(0,0,0), Time(12,0,0), Time(23,59,59) ) ) | List( Time(23,59,59), Time(11,59,59), Time(0,0,0) ) |
Related Content
-
Arithmetic Functions
Format:
Article,
1 min read