13-59
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 Managing Reports
Organizing Report Data
ROUNDDOWN(num) Rounds a number down. ROUNDDOWN([StockPrice])
ROUNDDOWN(num, dec) Rounds a number down, away from 0, to the
specified number of digits. The default value for dec
is 0.
ROUNDDOWN([StockPrice], 2)
ROUNDUP(num) Rounds a number up. ROUNDUP([TotalValue])
ROUNDUP(num, dec) Rounds a number up, away from 0, to the specified
number of digits. The default value for dec is0.
ROUNDUP([TotalValue], 2)
RUNNINGSUM(expr) Displays a running total, adding the values in
successive data rows.
RUNNINGSUM([StockValue])
SEARCH(pattern, str) Case-insensitive search function that can use
wildcard characters.
An asterisk ( * ) matches any sequence of
characters, including spaces.
A question mark ( ? ) matches any single character.
The following search yields New York,
New Haven, and so on from the City
column:
SEARCH([CustomerData:city], "new*")
SEARCH(pattern, str,
startPosition)
Searches for a specified pattern in a string, starting
at a specified position in the string. A
case-insensitive search function that can use
wildcard characters.
SEARCH([Location], "new", 1)
SQRT(num) Displays the square root of a value. SQRT([PrincipalValue])
STDEV(expr) Displays the standard deviation. STDEV([PurchaseFrequency])
SUM(expr) Displays the sum of two specified values. SUM([Price]+[Tax])
TODAY() Displays a time stamp value equal to midnight of
the current date.
TODAY([DueDate])
TRIM(str) Displays a string with all leading and trailing blank
characters removed. Also removes all consecutive
blank characters. Leading and trailing blanks can be
spaces, tabs, and so on.
TRIM([customerName])
TRIMLEFT(str) Displays a string with all leading blanks removed.
Does not remove consecutive blank characters.
TRIMLEFT([PortfolioName])
TRIMRIGHT(str) Displays a string with all trailing blanks removed.
Does not remove consecutive blank characters.
TRIMRIGHT([Comments])
True The Boolean True. This function is used in
expressions to indicate that an argument is true.
In the following example, True indicates
that the second argument, ascending, is
true and therefore the values should be
returned in ascending order.
RANK([Score], true)
UPPER(str) Displays a string in a specified column in all
uppercase.
UPPER([cityName])
UPPER("new haven")
VAR(expr) Displays a variance for the specified expression. VAR([EstimatedCost])
WEEK(date) Displays the number of the week, from 1 through
52, for a date-and-time value.
WEEK([LeadQualifyingDate])
Table13-11 Examples of Functions (continued)
Function Description Example of use