Cisco Systems OL-24201-01 manual Isbottomnpercent, 13-55

Chapter 13 Managing Reports

Organizing Report Data

Table 13-11		Examples of Functions (continued)
	Function		Description	Example of use
	FIRST(expr, groupLevel)		Displays the first value that appears in the specified	FIRST([customerID], 3)
			column at the specified group level.
	IF(condition, doIfTrue,		Displays the result of an If...Then...Else statement.	IF([purchaseVolume] >5 , 7 , 0)
	doIfFalse)			where
				• [purchaseVolume] is the column
				name and >5 is the test condition.
				• 7 is the value to place in the new
				column if the condition is true.
				• 0 is the value to place in the new
				column if the condition is false.
	IN(value, check)		Displays True if a data row contains a value	IN([custID], 101)
			specified by the check argument and False	IN([city], "New Haven")
			otherwise.	IN([FinishTime], "16:09")
			String values and date or time values must be
			enclosed in quotation marks. For dates and times,
			use the short date and short time formats for your
			locale.
	IN(value, check1, ...,		Displays True if a data row contains any value	IN([city], “New Haven”, “Baltimore”,
	checkN)		specified by the check argument list and False	“Cooperstown”)
			otherwise.	IN([ShipDate], “05/01/06”,
				“05/10/06”, “05/15/06”)
			String values and date or time values must be
			enclosed in quotation marks. For dates and times,
			use the short date and short time formats for your
			locale.
	ISBOTTOMN(expr, n)		Displays True if the value is within the lowest n	ISBOTTOMN([OrderTotals], 50)
			values for the expression, and False otherwise.
	ISBOTTOMN(expr, n,		Displays True if the value is within the lowest n	ISBOTTOMN([OrderTotals], 50, 2)
	groupLevel)		values for the expression at the specified group
			level, and False otherwise.
	ISBOTTOMNPERCENT		Displays the lowest n percentage.	ISBOTTOMNPERCENT([Sales Total], 5)
	(expr, percent)
	ISBOTTOMNPERCENT		Displays the lowest n percentage for the expression	ISBOTTOMNPERCENT([Sales Total], 5,
	(expr, percent, groupLevel)		at the specified group level.	3)
	ISNULL(value)		Displays True if a row does not display a value.	ISNULL([DepartmentName])
			Displays False if a row displays a value.
	ISTOPN(expr, n)		Displays True if the value is within the highest n	ISTOPN([OrderTotals], 10)
			values for the expression, and False otherwise.
	ISTOPN(expr, n,		Displays True if the value is within the highest n	ISTOPN([OrderTotals], 10, 3)
	groupLevel)		values for the expression at the specified group
			level, and False otherwise.
	ISTOPNPERCENT(expr,		Displays True if the value is within the highest n	ISTOPNPERCENT([SalesTotals], 5)
	percent)		percentage, and False otherwise.
			User Guide for Cisco Secure Access Control System 5.3
	OL-24201-01				13-55