Comparison Operators

BetweenExclusive
returns true if the first value is within the range defined by the second and third values (excluding the bounding values).
For example, X BetweenExclusive(50, 100) returns true if X is greater than 50 and less than 100.
BetweenInclusive
returns true if the first value is within the range defined by the second and third values (including the bounding values).
For example, X BetweenInclusive(50, 100) returns true if X is greater than or equal to 50 and less than or equal to 100.
In
returns true if the first value is in the list specified by the second parameter. Select your list by choosing the values from the drop-down list or the selector window.
For example, X In ('A', 'B', 'C') returns true when the value of X is either A, B, or C.
Note: This operator cannot be used to compare measures.
Missing
returns true if the value is a missing value.
For example, X Missing returns true if the value of X is missing.
NotBetweenExclusive
returns true if the first value is outside the range defined by the second and third values (excluding the bounding values).
For example, X NotBetweenExclusive(50, 100) returns true if X is less than 50 or greater than 100.
NotBetweenInclusive
returns true if the first value is outside the range defined by the second and third values (including the bounding values).
For example, X NotBetweenInclusive(50, 100) returns true if X is less than or equal to 50 or greater than or equal to 100.
NotIn
returns true if the first value is not in the list specified by the second parameter. Select your list by choosing the values from the drop-down list or the selector window.
For example, X NotIn ('A', 'B', 'C') returns true when the value of X is not A, B, or C.
Note: This operator cannot be used to compare measures.
NotMissing
returns true if the value is not a missing value.
For example, X NotMissing returns true if the value of X is not missing.
x < y
returns true if the first value is less than the second value.
x <= y
returns true if the first value is less than or equal to the second value.
x <> y
returns true if the first value is not equal to the second value.
x = y
returns true if the first value is equal to the second value.
x > y
returns true if the first value is greater than the second value.
x >= y
returns true if the first value is greater than or equal to the second value.
Last updated: January 8, 2019