Filter
Top Products
13-56
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Organizing Report Data
ISBOTTOMN(expr, n) Displays True if the value is within the lowest n
values for the expression, and False otherwise.
ISBOTTOMN([OrderTotals], 50)
ISBOTTOMN(expr, n,
groupLevel)
Displays True if the value is within the lowest n
values for the expression at the specified group
level, and False otherwise.
ISBOTTOMN([OrderTotals], 50, 2)
ISBOTTOMNPERCENT
(expr, percent)
Displays the lowest n percentage.
ISBOTTOMNPERCENT([Sales Total], 5)
ISBOTTOMNPERCENT
(expr, percent, groupLevel)
Displays the lowest n percentage for the expression
at the specified group level.
ISBOTTOMNPERCENT([Sales Total], 5,
3)
ISNULL(value) Displays True if a row does not display a value.
Displays False if a row displays a value.
ISNULL([DepartmentName])
ISTOPN(expr, n) Displays True if the value is within the highest n
values for the expression, and False otherwise.
ISTOPN([OrderTotals], 10)
ISTOPN(expr, n,
groupLevel)
Displays True if the value is within the highest n
values for the expression at the specified group
level, and False otherwise.
ISTOPN([OrderTotals], 10, 3)
ISTOPNPERCENT(expr,
percent)
Displays True if the value is within the highest n
percentage, and False otherwise.
ISTOPNPERCENT([SalesTotals], 5)
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])
Table 13-11 Examples of Functions (continued)
Function Description Example of use