Cisco Systems OL-24201-01 manual Today, 13-58

Chapter 13 Managing Reports

Organizing Report Data

Table 13-11	Examples of Functions (continued)
Function		Description	Example of use
RANK(expr)		Displays the rank of a number, string, or	RANK([AverageStartTime])
		date-and-time value, starting at 1. Duplicate values
		receive identical rank but the duplication does not
		affect the ranking of subsequent values.
RANK(expr, ascending,		Displays the rank of a number, string, or	RANK([Score], false, 3)
groupLevel)		date-and-time value in either ascending or	RANK([Score], true, 2)
		descending order, at the specified group level.
		To display values in ascending order, use True as the
		second argument. To display values in descending
		order, use False as the second argument.
RIGHT(str)		Displays the character at the right of a string.	RIGHT([name])
RIGHT(str, n)		Displays the specified number of characters in a	RIGHT([name], 3)
		string, counting from the right.
ROUND(num)		Rounds a number.	ROUND([SalesTarget])
ROUND(num, dec)		Rounds a number to the specified number of digits.	ROUND([StockValue], 2)
		The default value for dec is 0.
ROUNDDOWN(num)		Rounds a number down.	ROUNDDOWN([StockPrice])
ROUNDDOWN(num, dec)		Rounds a number down, away from 0, to the	ROUNDDOWN([StockPrice], 2)
		specified number of digits. The default value for dec
		is 0.
ROUNDUP(num)		Rounds a number up.	ROUNDUP([TotalValue])
ROUNDUP(num, dec)		Rounds a number up, away from 0, to the specified	ROUNDUP([TotalValue], 2)
		number of digits. The default value for dec is 0.
RUNNINGSUM(expr)		Displays a running total, adding the values in	RUNNINGSUM([StockValue])
		successive data rows.
SEARCH(pattern, str)		Case-insensitive search function that can use	The following search yields New York,
		wildcard characters.	New Haven, and so on from the City
		An asterisk ( * ) matches any sequence of	column:
		characters, including spaces.	SEARCH([CustomerData:city], "new*")
		A question mark ( ? ) matches any single character.
SEARCH(pattern, str,		Searches for a specified pattern in a string, starting	SEARCH([Location], "new", 1)
startPosition)		at a specified position in the string. A
		case-insensitive search function that can use
		wildcard characters.
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	TODAY([DueDate])
		the current date.

	User Guide for Cisco Secure Access Control System 5.3
13-58	OL-24201-01