Skip to main content

Comparison operators in Expression Editor

Calculate values, compare numbers or text, combine conditions, and test boundary values in Yeeflow Expression Editor.

Use operators in Yeeflow Expression Editor to calculate values, compare fields with target values, and combine conditions that return true or false. A rule that applies at 100 or more includes 100 itself.

Overview of operators

Arithmetic and parentheses

  • Use + to add numbers or join text. 1 + 3 gives 4. Joining the text values A and B gives AB.

  • Use - to subtract. 3 - 1 gives 2.

  • Use * to multiply. 3 * 4 gives 12.

  • Use / to divide. 15 / 3 gives 5.

  • Use % to return the remainder. 8 % 5 gives 3.

  • Use a matching pair of ( and ) to group a calculation. 3 * (5 + 3) gives 24.

Compare numbers or text

  • Use == to test equality and != to test inequality.

  • Use > for greater than and >= for greater than or equal to.

  • Use < for less than and <= for less than or equal to.

Check that the two inputs have the intended types. For example, compare an amount field with a number. If the amount is 100, amount > 100 is false and amount >= 100 is true.

Combine conditions with and and or

  • and is true when both conditions are true. For example, 7 > 0 and 5 > 8 is false.

  • or is true when at least one condition is true. For example, 7 > 0 or 5 > 8 is true.

Use parentheses to group parts of a compound expression. To return different values based on the outcome, see Predefined functions in Expression Editor.

Test boundary values

For a rule that applies at 100 or more, select the amount field, >=, and the number 100. Preview the rule with 99, 100, and 101. Only 100 and 101 should pass. Use > if the amount must exceed 100.

Yeeflow threshold example. Both conditions are false at 99. Only greater than or equal to 100 is true at 100. Both conditions are true at 101.

Select the actual fields, variables, and numbers in your editor. This example uses an amount field. Understand Expression Editor · Use expressions for data calculations

Did this answer your question?