Cisco Systems OL-24201-01 manual Understanding Supported Calculation Functions, 13-53

Chapter 13 Managing Reports

Organizing Report Data

Understanding Supported Calculation Functions

Table 13-11provides examples of the functions you can use to create calculations.

Note The Calculation dialog box does not support the use of uppercase TRUE and FALSE functions in expressions.Calculation also does not support the use of initial capital letters for True and False. These functions must be expressed in lowercase only.

Table 13-11		Examples of Functions
	Function		Description	Example of use
	ABS(num)		Displays an absolute value for the data in a column.	ABS([TemperatureCelsius])
	ADD_DAY(date,		Adds a specified number of days to a date value and	ADD_DAY([ClosingDate], 30)
	daysToAdd)		displays the result as a date value.
	ADD_HOUR(date,		Adds a specified number of hours to a time value	ADD_HOUR([OpenHour], 8)
	hoursToAdd)		and displays the result as a time value.
	ADD_MINUTE(date,		Adds a specified number of minutes to a time value	ADD_MINUTE([StartTime], 60)
	minutesToAdd)		and displays the result as a time value.
	ADD_MONTH(date,		Adds a specified number of months to a date value	ADD_MONTH([InitialRelease], 2)
	monthsToAdd)		and displays the result as a date value.
	ADD_QUARTER(date,		Adds a specified number of quarters to a date value.	ADD_QUARTER([ForecastClosing], 2)
	quartersToAdd)
	ADD_SECOND(date,		Adds a specified number of seconds to a time value.	ADD_SECOND([StartTime], 30)
	secondsToAdd)
	ADD_WEEK(date,		Adds a specified number of weeks to a date value	ADD_WEEK([askByDate], 4)
	weeksToAdd)		and displays the result as a date value.
	ADD_YEAR(date,		Adds a specified number of years to a date value.	ADD_YEAR([HireDate], 5)
	yearsToAdd)
	AND		Combines two conditions and returns records that	This function is used to connect clauses in
			match both conditions. For example, you can	an expression and does not take
			request records from customers who spend more	arguments.
			than $50,000 a year and also have a credit rank of A.
	AVERAGE(expr)		Displays an average value for the column.	AVERAGE([CostPerUnit])
	AVERAGE(expr,		Displays the average value at the specified group	AVERAGE([TotalCost], 2)
	groupLevel)		level.
	BETWEEN(value,		For a specified column, displays True if a value is	BETWEEN([PostalCode], 11209, 12701)
	upperBound, lowerBound)		between two specified values and False otherwise.	BETWEEN([ReceiptDate],
			String values and date or time values must be	“10/01/06”, “12/31/06”)
			enclose in quotation marks. For dates and times, use
			the short date and short time formats.
	CEILING(num,		Rounds a number up, away from 0, to the nearest	CEILING([PortfolioAverage], 1)
	significance)		specified multiple of significance.
			For data that has been converted from a double or
			float to an integer, displays the smallest integer that
			is greater than or equal to the float or double.
			User Guide for Cisco Secure Access Control System 5.3
	OL-24201-01				13-53