Cisco Systems OL-24201-01 manual Weightedaverage, 13-59

Chapter 13 Managing Reports

Organizing Report Data

Table 13-11	Examples of Functions (continued)
Function		Description	Example of use
TRIM(str)		Displays a string with all leading and trailing blank	TRIM([customerName])
		characters removed. Also removes all consecutive
		blank characters. Leading and trailing blanks can be
		spaces, tabs, and so on.
TRIMLEFT(str)		Displays a string with all leading blanks removed.	TRIMLEFT([PortfolioName])
		Does not remove consecutive blank characters.
TRIMRIGHT(str)		Displays a string with all trailing blanks removed.	TRIMRIGHT([Comments])
		Does not remove consecutive blank characters.
True		The Boolean True. This function is used in	In the following example, True indicates
		expressions to indicate that an argument is true.	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	UPPER([cityName])
		uppercase.	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	WEEK([LeadQualifyingDate])
		52, for a date-and-time value.
WEEKDAY(date, option)		Displays the day of the week in one of the following	WEEKDAY([DateSold], 4)
		format options:
		• 1 - Returns the day number, from 1 (Sunday)
		through 7 (Saturday). 1 is the default option.
		• 2 - Returns the day number, from 1 (Monday)
		through 7 (Sunday).
		• 3 - Returns the day number, from 0 (Monday)
		through 6 (Sunday).
		• 4 - Returns the weekday name according to the
		user’s locale.
		• 5 - Returns the abbreviated weekday name
		according to the user’s locale.
WEIGHTEDAVERAGE		Displays a weighted average of a specified value.	WEIGHTEDAVERAGE([Score], weight)
(value, weight)
YEAR(date)		Displays the four-digit year value for a	YEAR([ClosingDate])
		date-and-time value.

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