Documentation forTask Factory

Task Factory Functions List O-Q

 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.
Syntax PV( Rate, Terms, Payment [, Future_Value] [, Type] )
Returns Numeric.
Parameters
Name Optional Description
Rate false 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.
Examples
PV(Ratevar, Termvar, Paymentvar), PV(3.25, 36, 125.50, 5000, 1)

Quarter

Description Returns the Quarter from the date specified.
Syntax Quarter( Date )
Returns returns integer value of 1 - 4
Parameters
Name Optional Description
Date false Date to retrieve Quarter from
Examples
Quarter("12/8/2011"), Quarter(varDate), Quarter(OrderDateColumn)