FUNCTION:  FormatPercent( )

Implemented in version 2.0

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%

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%