Comparison Operators

When the rules in attribute adjustments use comparison operators such as the greater than (>) and less than (<) operators:

  • The data types of the condition dimensions must be number or date.

  • Pay special attention to the following:

  • Whether the rule must act on all the rows of data when you enter the values that the conditions must match

  • The Sort Order properties of the dimensions. Blanking out or duplicating the sort order will give undefined results.

  • The Sort Order and Sort Method fields of the dimensions. These fields determine the order in which the rules are processed, and you must select values that minimize the number of records that must be processed.