Filter
Top Products
13-58
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Organizing Report Data
OR The logical OR operator. This function is used to connect clauses in
an expression and does not take
arguments.
PERCENTILE(expr, pct) Displays a percentile value, a value on a scale of
100 that indicates the percent of a distribution that
is equal to or below the specified value.
Valid pct argument ranges are 0 to 1. 0 returns the
minimum value of the series. 1 returns the
maximum value of the series.
PERCENTILE([Rank], 1)
PERCENTILE(expr, pct,
groupLevel)
Displays a percentile value for the expression at the
specified group level.
Valid pct argument ranges are 0 to 1. 0 returns the
minimum value of the series. 1 returns the
maximum value of the series.
PERCENTILE([Income], 60, 1)
PERCENTRANK(expr) Displays the percentage rank of a value.
PERCENTRANK([TestScores])
PERCENTRANK(expr,
groupLevel)
Displays the percentage rank of a value at the
specified group level.
PERCENTRANK([TestScores], 2)
PERCENTSUM(expr) Displays a value as a percentage of a total.
PERCENTSUM([OrderTotals])
PERCENTSUM(expr,
groupLevel)
Displays a value as a percentage of a total at the
specified group level.
PERCENTSUM([OrderTotals], 3)
QUARTER(date) Displays the quarter number, from 1 through 4, of a
specified date-and-time value.
QUARTER([ForecastCloseDate])
QUARTILE(expr, quart) Displays the quartile value, where the quart
argument is an integer between 0 and 4.
QUARTILE([OrderTotal], 3)
QUARTILE(expr, quart,
groupLevel)
Displays the quartile value for the expression at the
specified group level, where the quart argument is
an integer between 0 and 4.
QUARTER([OrderTotal], 2, 3)
RANK(expr) Displays the rank of a number, string, or
date-and-time value, starting at 1. Duplicate values
receive identical rank but the duplication does not
affect the ranking of subsequent values.
RANK([AverageStartTime])
RANK(expr, ascending,
groupLevel)
Displays the rank of a number, string, or
date-and-time value in either ascending or
descending order, at the specified group level.
To display values in ascending order, use True as the
second argument. To display values in descending
order, use False as the second argument.
RANK([Score], false, 3)
RANK([Score], true, 2)
RIGHT(str) Displays the character at the right of a string.
RIGHT([name])
RIGHT(str, n) Displays the specified number of characters in a
string, counting from the right.
RIGHT([name], 3)
ROUND(num) Rounds a number.
ROUND([SalesTarget])
ROUND(num, dec) Rounds a number to the specified number of digits.
The default value for dec is 0.
ROUND([StockValue], 2)
Table 13-11 Examples of Functions (continued)
Function Description Example of use