Financial |
Top Previous Next |
These functions are related to financial operations, such as properly rounding or formatting amounts for your currency.
| Function: | Ceiling |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Returns a value representing the smallest integer that is greater than or equal to nValue |
| Function: | Currency |
| Result-type: | Text |
| Arguments: | nValue |
| Description: | Converts a numeric value into currency text. Example: 3.5 -> '$3.50' |
Function: CurrencyTextToValue
Result-type: Numeric
Arguments: cText
Description: Converts a text currency value to a numeric value. Example: '$3.50' -> 3.5
| Function: | Floor |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Returns a value representing the largest integer that is less than or equal to nValue |
| Function: | Int |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Truncates a number to an integer |
| Function: | Percent |
| Result-type: | Text |
| Arguments: | nValue |
| Description: | Converts a numeric value into percentage text. Example: 3.5 -> '3.5%' |
| Function: | Round |
| Result-type: | Numeric |
| Arguments: | nValue, nDecimalPlaces |
| Description: | Rounds a value to the given number of decimal places |
| Function: | Sign |
| Result-type: | Numeric |
| Arguments: | nValue |
| Description: | Returns -1 if the value is less than 0, 1 if the value is greater than 0, or 0 if it's exactly 0 |