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

DescriptionConverts a octal value to a binary value.
SyntaxOctToBin( Value )
ReturnsString
Parameters
NameOptionalDescription
ValuefalseThe octal value to convert.
Examples
OctToBin(10)

OctToDecimal

DescriptionConverts a octal value to a binary value.
SyntaxOctToDecimal( Value )
ReturnsString
Parameters
NameOptionalDescription
ValuefalseThe octal value to convert.
Examples
OctToDecimal(10)

OctToHex

DescriptionConverts a octal value to a binary value.
SyntaxOctToHex( Value )
ReturnsString
Parameters
NameOptionalDescription
ValuefalseThe octal value to convert.
Examples
OctToHex(10)

Power

DescriptionReturns a specified number to a specified power.
SyntaxPower( Value1, Value2 )
ReturnsNumeric
Parameters
NameOptionalDescription
Value1falseA double-precision floating-point number to be raised to a power.
Value2falseA double-precision floating-point number that specifies a power.
Examples
Power(10, 3)

PV

DescriptionReturns the present value of an investment, where you make periodic, constant payments and the investment earns a constant interest rate.
SyntaxPV( Rate, Terms, Payment [, Future_Value] [, Type] )
ReturnsNumeric.
Parameters
NameOptionalDescription
RatefalseNumeric. 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.
TermsfalseNumeric. Number of periods or payments. Must be greater than 0.
PaymentfalseNumeric. Payment amount due per period. Must be a negative number.
Future_ValuetrueNumeric. Future value/balance of the investment. If you omit this argument, PV uses 0.
TypetrueInteger. 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

DescriptionReturns the Quarter from the date specified.
SyntaxQuarter( Date )
Returnsreturns integer value of 1 - 4
Parameters
NameOptionalDescription
DatefalseDate to retrieve Quarter from
Examples
Quarter("12/8/2011"), Quarter(varDate), Quarter(OrderDateColumn)