Task Factory users running version 2020.1.4 or older (released prior to May 27, 2020): There's an important Task Factory update. Please visit here for more details.
OctToBin
Description
Converts a octal value to a binary value.
Syntax
OctToBin( Value )
Returns
String
Parameters
Name
Optional
Description
Value
false
The octal value to convert.
Examples
OctToBin(10)
OctToDecimal
Description
Converts a octal value to a binary value.
Syntax
OctToDecimal( Value )
Returns
String
Parameters
Name
Optional
Description
Value
false
The octal value to convert.
Examples
OctToDecimal(10)
OctToHex
Description
Converts a octal value to a binary value.
Syntax
OctToHex( Value )
Returns
String
Parameters
Name
Optional
Description
Value
false
The octal value to convert.
Examples
OctToHex(10)
Power
Description
Returns a specified number to a specified power.
Syntax
Power( Value1, Value2 )
Returns
Numeric
Parameters
Name
Optional
Description
Value1
false
A double-precision floating-point number to be raised to a power.
Value2
false
A double-precision floating-point number that specifies a power.
Examples
Power(10, 3)
PV
Description
Returns the present value of an investment, where you make periodic, constant payments and the investment earns a constant interest rate.
Numeric. Interest rate earned in each period. Expressed as a decimal number. Divide the percent rate by 100 to express it as a decimal number. Must be greater than or equal to 0.
Terms
false
Numeric. Number of periods or payments. Must be greater than 0.
Payment
false
Numeric. Payment amount due per period. Must be a negative number.
Future_Value
true
Numeric. Future value/balance of the investment. If you omit this argument, PV uses 0.
Type
true
Integer. Timing of the payment. Enter 1 if payment is at the beginning of period. Enter 0 if payment is at the end of period. Default is 0. If you enter a value other than 0 or 1, the Integration Service treats the value as 1.