Filter
Top Products
13-55
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
FIRST(expr, groupLevel) Displays the first value that appears in the specified
column at the specified group level.
FIRST([customerID], 3)
IF(condition, doIfTrue,
doIfFalse)
Displays the result of an If...Then...Else statement.
IF([purchaseVolume] >5 , 7 , 0)
where
• [purchaseVolume] is the column
name and >5 is the test condition.
• 7 is the value to place in the new
column if the condition is true.
• 0 is the value to place in the new
column if the condition is false.
IN(value, check) Displays True if a data row contains a value
specified by the check argument and False
otherwise.
String values and date or time values must be
enclosed in quotation marks. For dates and times,
use the short date and short time formats for your
locale.
IN([custID], 101)
IN([city], "New Haven")
IN([FinishTime], "16:09")
IN(value, check1, ...,
checkN)
Displays True if a data row contains any value
specified by the check argument list and False
otherwise.
String values and date or time values must be
enclosed in quotation marks. For dates and times,
use the short date and short time formats for your
locale.
IN([city], “New Haven”, “Baltimore”,
“Cooperstown”)
IN([ShipDate], “05/01/06”,
“05/10/06”, “05/15/06”)
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)
Table 13-11 Examples of Functions (continued)
Function Description Example of use