Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Arithmetic Functions

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

This article applies to:

  • Product: Contract Express