Filter
Top Products
13-59
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
TRIM(str) Displays a string with all leading and trailing blank
characters removed. Also removes all consecutive
blank characters. Leading and trailing blanks can be
spaces, tabs, and so on.
TRIM([customerName])
TRIMLEFT(str) Displays a string with all leading blanks removed.
Does not remove consecutive blank characters.
TRIMLEFT([PortfolioName])
TRIMRIGHT(str) Displays a string with all trailing blanks removed.
Does not remove consecutive blank characters.
TRIMRIGHT([Comments])
True The Boolean True. This function is used in
expressions to indicate that an argument is true.
In the following example, True indicates
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
uppercase.
UPPER([cityName])
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
52, for a date-and-time value.
WEEK([LeadQualifyingDate])
WEEKDAY(date, option) Displays the day of the week in one of the following
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.
WEEKDAY([DateSold], 4)
WEIGHTEDAVERAGE
(value, weight)
Displays a weighted average of a specified value.
WEIGHTEDAVERAGE([Score], weight)
YEAR(date) Displays the four-digit year value for a
date-and-time value.
YEAR([ClosingDate])
Table 13-11 Examples of Functions (continued)
Function Description Example of use