Operators

Operators specify what happens to the values on either side of the operator. Operators are similar to functions, in that they manipulate data items and return a result.

(
Identifies the beginning of an expression.
)
Identifies the end of an expression.
*
Multiplies two numeric values.
,
Separates expression components.
/
Divides two numeric values.
||
Concatenates, or joins, strings.
+
Adds two numeric values.
-
Subtracts two numeric values or negates a numeric value.
<
Compares the values that are represented by "value1" against "value2" and retrieves the values that are less than "value2".
<=
Compares the values that are represented by "value1" against "value2" and retrieves the values that are less than or equal to "value2".
<>
Compares the values that are represented by "value1" against "value2" and retrieves the values that are not equal to "value2".
=
Compares the values that are represented by "value1" against "value2" and retrieves the values that are equal to "value2".
>
Compares the values that are represented by "value1" against "value2" and retrieves the values that are greater than "value2".
->
Separates the components in a literal member expression.
>=
Compares the values that are represented by "value1" against "value2" and retrieves the values that are greater than or equal to "value2".
and
Returns "true" if the conditions on both sides of the expression are true.
auto
Works with summary expressions to define the scope to be adjusted based on the grouping columns in the query. The scope is context-dependent.
between
Determines if a value falls in a given range.
case
Works with when, then, else, and end. Case identifies the beginning of a specific situation, in which when, then, and else actions are defined.
contains
Determines if "string1" contains "string2".
currentMeasure
Keyword that can be used as the first argument of member summary functions. This function appears in the Total Revenue by Country sample report in the GO Data Warehouse (query) package.
default
Works with the lookup construct.
distinct
A keyword used in an aggregate expression to include only distinct occurrences of values. See also the function unique.
else
Works with the if or case constructs. If the if condition or the case expression are not true, then the else expression is used. This function appears in the Top 10 Retailers for 2005 sample report in the GO Data Warehouse (analysis) package.
end
Indicates the end of a case or when construct.
ends with
Determines if "string1" ends with "string2".
escape
Determines if "string1" matches the pattern of "string2", with the character "char" optionally used to escape characters in the pattern string.
for
Works with summary expressions to define the scope of the aggregation in the query.
for all
Works with summary expressions to define the scope to be all the specified grouping columns in the query. See also the for clause.
for any
Works with summary expressions to define the scope to be adjusted based on a subset of the grouping columns in the query. Equivalent to the for clause.
for report
Works with summary expressions to set the scope to be the whole query. See also the for clause. This function appears in the Customer Returns and Satisfaction sample report in the GO Data Warehouse (analysis) package.
if
Works with the then and else constructs. If defines a condition; when the if condition is true, the then expression is used. When the if condition is not true, the else expression is used. This function appears in the Top 10 Retailers for 2005 sample report in the GO Data Warehouse (analysis) package.
in
Determines if "expression1" exists in a given list of expressions.
in_range
Determines if "expression1" exists in a given list of constant values or ranges.
is missing
Determines if "value" is undefined in the data.
is null
Determines if "value" is undefined in the data.
is not missing
Determines if "value" is defined in the data.
is not null
Determines if "value" is defined in the data.
like
Determines if "string1" matches the pattern of "string2", with the character "char" optionally used to escape characters in the pattern string.
lookup
Finds and replaces data with a value you specify. It is preferable to use the case construct.
not
Returns TRUE if "argument" is false or returns FALSE if "argument" is true.
or
Returns TRUE if either of "argument1" or "argument2" are true.
prefilter
Performs a summary calculation before applying the summary filter.
rows
Counts the number of rows output by the query. Use with Count ().
rows
Counts the number of rows output by the query. Use with Count ().
starts with
Determines if "string1" starts with "string2".
then
Works with the if or case constructs. When the if condition or the when expression are true, the then expression is used. This function appears in the Top 10 Retailers for 2005 sample report in the GO Data Warehouse (analysis) package.
when
Works with the case construct. You can define conditions to occur when the WHEN expression is true.

Parent topic: Using the expression editor