Filter
Top Products
13-54
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
COUNT( ) Counts the rows in a table.
COUNT( )
COUNT(groupLevel) Counts the rows at the specified group level.
COUNT(2)
COUNTDISTINCT(expr) Counts the rows that contain distinct values in a
table.
COUNTDISTINCT([CustomerID])
COUNTDISTINCT([Volume]*2)
COUNTDISTINCT
(expr, groupLevel)
Counts the rows that contain distinct values at the
specified group level.
COUNTDISTINCT([CustomerID], 3)
DAY(date) Displays the number of a day in the month, from 1
to 31, for a date-and-time value.
DAY([forecastShipping])
DIFF_DAY(date1, date2) Displays the difference between two date values, in
the number of days.
DIFF_DAY([checkoutDate],
[returnDate])
DIFF_HOUR(date1, date2) Displays the difference between two time values, in
the number of hours.
DIFF_HOUR([StartTime],[Finish
Time])
DIFF_MINUTE(date1,
date2)
Displays the difference between two time values, in
the number of minutes.
DIFF_MINUTE([StartTime],
[FinishTime])
DIFF_MONTH(date1,
date2)
Displays the difference between two date values, in
the number of months.
DIFF_MONTH([askByDate],
[shipByDate])
DIFF_QUARTER(date1,
date2)
Displays the difference between two date values, in
the number of quarters.
DIFF_QUARTER([PlanClosing],
[ActualClosing])
DIFF_SECOND(date1,
date2)
Displays the difference between two time values, in
the number of seconds.
DIFF_SECOND([StartTime],
[FinishTime])
DIFF_WEEK(date1, date2) Displays the difference between two weeks as a
number.
DIFF_WEEK([askByDate],
[shipByDate])
DIFF_YEAR(date1, date2) Displays the difference between two years as a
number.
DIFF_YEAR([HireDate],
[TerminationDate])
False The Boolean False. This function is used in
expressions to indicate that an argument is false.
In the following example, False indicates
that the second argument, ascending, is
false and therefore the values should be
returned in descending order.
RANK([Score], false)
FIND(strToFind, str) Displays the index of the first occurrence of
specified text. The index is zero-based. The search
is case sensitive and the search string cannot include
wildcards.
The value in the strToFind argument must be
enclosed in quotation marks.
FIND("HQ", [OfficeName])
FIND(strToFind, str,
startPosition)
Similar to FIND(strToFind, str) but supports
providing a start position for the search. The index
is zero-based.
FIND("HQ", [OfficeName], 3)
FIRST(expr) Places the first value that appears in a specified
column into the calculated column. This function
supports viewing a row-by-row comparison against
a specific value.
FIRST([customerID])
Table 13-11 Examples of Functions (continued)
Function Description Example of use