Filter
Top Products
13-53
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter 13 Managing Reports
Organizing Report Data
Figure 13-38 Selecting a Function
Understanding Supported Calculation Functions
Table 13-11 provides 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,
daysToAdd)
Adds a specified number of days to a date value and
displays the result as a date value.
ADD_DAY([ClosingDate], 30)
ADD_HOUR(date,
hoursToAdd)
Adds a specified number of hours to a time value
and displays the result as a time value.
ADD_HOUR([OpenHour], 8)
ADD_MINUTE(date,
minutesToAdd)
Adds a specified number of minutes to a time value
and displays the result as a time value.
ADD_MINUTE([StartTime], 60)
ADD_MONTH(date,
monthsToAdd)
Adds a specified number of months to a date value
and displays the result as a date value.
ADD_MONTH([InitialRelease], 2)
ADD_QUARTER(date,
quartersToAdd)
Adds a specified number of quarters to a date value.
ADD_QUARTER([ForecastClosing], 2)
ADD_SECOND(date,
secondsToAdd)
Adds a specified number of seconds to a time value.
ADD_SECOND([StartTime], 30)
ADD_WEEK(date,
weeksToAdd)
Adds a specified number of weeks to a date value
and displays the result as a date value.
ADD_WEEK([askByDate], 4)
ADD_YEAR(date,
yearsToAdd)
Adds a specified number of years to a date value.
ADD_YEAR([HireDate], 5)