Filter
Top Products
13-60
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Organizing Report Data
Understanding Supported Operators
Table 13-12 describes the mathematical and logical operators you can use in writing expressions that
create calculated columns.
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.
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