FUNCTION: FormatPercent( )
Implemented in version 2.0
FormatPercent(Expression,
NumDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers,
GroupDigit)
The FormatPercent function return a formatted percent value
for the numeric expression with a following percent sign (%). A 1.0
converts to 100% and 0.0 converts to 0%.
There is one mandatory argument.
Expression
The Expression argument is the number to be converted to a
formatted percent.
Code:
<% =FormatPercent(.77) %>
Output:
77.00%
Note that this function rounds off values.
Code:
<% =FormatPercent(.678999) %>
Output:
67.90%
There are 4 optional arguments.
NumDigitsAfterDecimal
The optional NumDigitsAfterDecimal argument allows you
to choose the number of digits after the decimal.
Code:
<% =FormatPercent(.123456789, 4) %>
Output:
12.3457%
IncludeLeadingDigit
The optional IncludeLeadingDigit argument includes the
leading zero.
You must only use the constant or value from the Tristate CONSTANTS
for this argument.
| CONSTANT |
VALUE |
DESCRIPTION |
| TristateTrue |
-1 |
True, will
use options |
| TristateFalse |
0 |
False, will
not use options |
| TristateUseDefault |
-2 |
Use default
setting |
|
Code:
<% =FormatPercent(.0098, 4, -1) %>
Output:
0.9800%
UseParensForNegativeNumbers
The optional UseParensForNegativeNumber argument replaces
a negative sign with parentheses around the number.
You must only use the constant or value from the Tristate CONSTANTS
for this argument.
| CONSTANT |
VALUE |
DESCRIPTION |
| TristateTrue |
-1 |
True, will
use options |
| TristateFalse |
0 |
False, will
not use options |
| TristateUseDefault |
-2 |
Use default
setting |
|
Code:
<% =FormatPercent(-.77, 2, 0, -1) %>
Output:
(77.00%)
GroupDigit
The optional GroupDigit argument allows the use of the
options specified in the Regional Settings Properties in the Control
Panel to display a percent.
You must only use the constant or value from the TRISATE CONSTANTS
for this argument.
| CONSTANT |
VALUE |
DESCRIPTION |
| TristateTrue |
-1 |
True, will
use options |
| TristateFalse |
0 |
False, will
not use options |
| TristateUseDefault |
-2 |
Use default
setting |
|
Code:
<% =FormatPercent(.77, 2, 0, -1, -1) %>
Output:
77.00%
Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information
|