Cisco Systems OL-24201-01 manual Understanding Supported Operators, Operator Description, 13-60

Chapter 13 Managing Reports

Organizing Report Data

Understanding Supported Operators

Table 13-12describes the mathematical and logical operators you can use in writing expressions that create calculated columns.

Table 13-12	Supported Operators to Use in Writing Expressions
Operator	Description
x + y	Addition of numeric values
x - y	Subtraction of numeric values
x * y	Multiplication of numeric values
x / y	Division of numeric values
x%	Percentage of a numeric value
x & y	Concatenation of string values
x = y	Test for equality of two values
x > y	Tests whether x is greater than y
x < y	Tests whether x is less than y
x >= y	Tests whether x is greater than or equal to y
x <= y	Tests whether x is less than or equal to y
x <> y	Tests whether x is not equal to y
x AND y	Tests for values that meet both condition x and condition y
x OR y	Tests for values that meet either condition x or condition y
NOT x	Tests for values that are not x

Using Numbers and Dates in an Expression

When you create an expression that contains a number, you must type the number according to the conventions of the US English locale. In other words, use a period (.), not a comma (,), as the decimal separator. For example:

Correct: 1234.56

Incorrect: 1234,56

When you create an expression that contains a date, type the date according to the conventions of the locale you chose when you logged in. For example, in the French (France) locale type 03/12/2007 to represent December 3, 2007, not 12/03/2007. You can enter a date or a date and time. Dates and times must be enclosed in double quotes ("), for example:

"03/12/2007" "03/12/2007 11:00 AM"

ns.

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