Skip to content

NotEqual

aggregating category: comparison no `||`

Returns TRUE when all values (parameters or inputs) are different.

Without parameters the rule checks that every input differs. With parameters the listed values — static or field references — must all be unequal to produce a TRUE result.

Parameters

Nvalues Optional — accepts: field, BOOLEAN, DATE, FLOAT, INT, STRING

The Nth value to compare. May be a static value or a field reference. If no parameters are given, all available inputs are compared.

Input type

  • BOOLEAN
  • DATE
  • FLOAT
  • INT
  • STRING

Output type

  • BOOLEAN

Requires

  • All values must have the same type.

Examples

Compare all available inputs

NotEqual()

Three field references

NotEqual(:float1, :float2, :float3)

Mix static and field

NotEqual(17, :int)

See also

Equal, GreaterThan, GreaterThanOrEqual, LessThan, LessThanOrEqual