Task Factory Functions List O-Q
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) | ||