Filter
Top Products
13-56
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
ISTOPNPERCENT(expr,
percent, groupLevel)
Displays True if the value is within the highest n
percentage values for the expression at the specified
group level, and False otherwise.
ISTOPNPERCENT([SalesTotals],
5, 3)
LAST(expr) Displays the last value in a specified column.
LAST([FinishTime])
LAST(expr, groupLevel) Displays the last value for the expression at the
specified group level.
LAST([FinishTime], 3)
LEFT(str) Displays the character at the left of the specified
string.
LEFT([city])
LEFT(str, n) Displays the specified number of characters in a
column’s string, counting from the left.
LEFT([city], 3)
LEN(str) Displays the length of a string, including spaces and
punctuation marks.
LEN([Description])
LIKE(str) Displays True if the values match, and False
otherwise. Use SQL syntax to specify the string
pattern.
The following rules apply:
• Literal pattern characters must match exactly.
LIKE is case-sensitive.
• A percent character (%) matches zero or more
characters.
• An underscore character (_) matches any single
character.
• Escape a literal percent, underscore, or
backslash character (\) with a backslash
character.
LIKE([customerName], "D%")
LIKE([quantityOrdered], "2_")
LOWER(str) Displays the string in a specified column in
lowercase.
LOWER([cityName])
MAX(expr) Displays the highest value in the specified column.
MAX([OrderTotal])
MAX(expr, groupLevel) Displays the highest value for the expression at the
specified group level.
MAX([OrderTotal], 2)
MEDIAN(expr) Displays the median value in a specified column.
MEDIAN([HomePrices])
MEDIAN(expr,
groupLevel)
Displays the median value for the expression at the
specified group level.
MEDIAN([HomePrices], 2)
MIN(expr) Displays the lowest value in the specified column.
MIN([OrderTotal])
MIN(expr, groupLevel) Displays the lowest value for the expression at the
specified group level.
MIN([OrderTotal], 1)
MOD(num, div) Displays the remainder after a number is divided by
a divisor. The result has the same sign as the divisor.
MOD([Salary], 12)
MONTH(date) Displays the name of the month for a specified
date-and-time value.
MONTH([ForecastShipDate])
Table 13-11 Examples of Functions (continued)
Function Description Example of use