Cisco Systems OL-24201-01 manual 13-56

Chapter 13 Managing Reports

Organizing Report Data

Table 13-11	Examples of Functions (continued)
Function		Description	Example of use
ISTOPNPERCENT(expr,		Displays True if the value is within the highest n	ISTOPNPERCENT([SalesTotals],
percent, groupLevel)		percentage values for the expression at the specified	5, 3)
		group level, and False otherwise.
LAST(expr)		Displays the last value in a specified column.	LAST([FinishTime])
LAST(expr, groupLevel)		Displays the last value for the expression at the	LAST([FinishTime], 3)
		specified group level.
LEFT(str)		Displays the character at the left of the specified	LEFT([city])
		string.
LEFT(str, n)		Displays the specified number of characters in a	LEFT([city], 3)
		column’s string, counting from the left.
LEN(str)		Displays the length of a string, including spaces and	LEN([Description])
		punctuation marks.
LIKE(str)		Displays True if the values match, and False	LIKE([customerName], "D%")
		otherwise. Use SQL syntax to specify the string	LIKE([quantityOrdered], "2_")
		pattern.
		The following rules apply:
		• Literal pattern characters must match exactly.
		LIKE is case-sensitive.
		• A percent character (%) matches zero or more
		characters.
		• An underscore character (_) matches any single
		character.
		• Escape a literal percent, underscore, or
		backslash character (\) with a backslash
		character.
LOWER(str)		Displays the string in a specified column in	LOWER([cityName])
		lowercase.
MAX(expr)		Displays the highest value in the specified column.	MAX([OrderTotal])
MAX(expr, groupLevel)		Displays the highest value for the expression at the	MAX([OrderTotal], 2)
		specified group level.
MEDIAN(expr)		Displays the median value in a specified column.	MEDIAN([HomePrices])
MEDIAN(expr,		Displays the median value for the expression at the	MEDIAN([HomePrices], 2)
groupLevel)		specified group level.
MIN(expr)		Displays the lowest value in the specified column.	MIN([OrderTotal])
MIN(expr, groupLevel)		Displays the lowest value for the expression at the	MIN([OrderTotal], 1)
		specified group level.
MOD(num, div)		Displays the remainder after a number is divided by	MOD([Salary], 12)
		a divisor. The result has the same sign as the divisor.
MONTH(date)		Displays the name of the month for a specified	MONTH([ForecastShipDate])
		date-and-time value.

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