Cisco Systems OL-24201-01 manual Movingaverage, 13-57

Chapter 13 Managing Reports

Organizing Report Data

Table 13-11	Examples of Functions (continued)
Function		Description	Example of use
MONTH(date, option)		Displays the month of a specified date-and-time	MONTH([Semester], 2)
		value, in one of three optional formats:
		• 1 - Displays the month number of 1 through 12.
		• 2 - Displays the complete month name in the
		user’s locale.
		• 3 - Displays the abbreviated month name in the
		user’s locale.
MOVINGAVERAGE		Displays an average value over a specified window,	MOVINGAVERAGE([Price],
(expr, window)		such as an average price or volume over a number	[Days])
		of days.
NOTNULL(value)		For a specified column, displays True if a data value	NOTNULL([DepartmentID])
		is not empty. Displays False if a data value is empty.
NOW( )		Displays the current time stamp.	NOW([PastDueDate])
OR		The logical OR operator.	This function is used to connect clauses in
			an expression and does not take
			arguments.
PERCENTILE(expr, pct)		Displays a percentile value, a value on a scale of	PERCENTILE([Rank], 1)
		100 that indicates the percent of a distribution that
		is equal to or below the specified value.
		Valid pct argument ranges are 0 to 1. 0 returns the
		minimum value of the series. 1 returns the
		maximum value of the series.
PERCENTILE(expr, pct,		Displays a percentile value for the expression at the	PERCENTILE([Income], 60, 1)
groupLevel)		specified group level.
		Valid pct argument ranges are 0 to 1. 0 returns the
		minimum value of the series. 1 returns the
		maximum value of the series.
PERCENTRANK(expr)		Displays the percentage rank of a value.	PERCENTRANK([TestScores])
PERCENTRANK(expr,		Displays the percentage rank of a value at the	PERCENTRANK([TestScores], 2)
groupLevel)		specified group level.
PERCENTSUM(expr)		Displays a value as a percentage of a total.	PERCENTSUM([OrderTotals])
PERCENTSUM(expr,		Displays a value as a percentage of a total at the	PERCENTSUM([OrderTotals], 3)
groupLevel)		specified group level.
QUARTER(date)		Displays the quarter number, from 1 through 4, of a	QUARTER([ForecastCloseDate])
		specified date-and-time value.
QUARTILE(expr, quart)		Displays the quartile value, where the quart	QUARTILE([OrderTotal], 3)
		argument is an integer between 0 and 4.
QUARTILE(expr, quart,		Displays the quartile value for the expression at the	QUARTER([OrderTotal], 2, 3)
groupLevel)		specified group level, where the quart argument is
		an integer between 0 and 4.

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