Skip to main content

ISEVEN

Use the ISEVEN function check if a number value is even.

Use

ISEVEN( value )
Returns TRUE if the number is even.

ParameterRequiredDescription
valueYesany number value to test

ReturnsLogical

Examples

Validating "Pairs-Only" Orders

In an Output Validation Formula, you can use ISEVEN to ensure that a user enters a quantity for an item that is only sold or processed in pairs.

  • Scenario: A company orders specialized equipment that must always be purchased in sets of two.
  • Formula: ISEVEN(this)
  • Logic: The keyword this represents the number the user entered in the "Quantity" field. If the user enters 4, the formula returns TRUE (valid); if they enter 5, it returns FALSE (invalid). You can wrap this in an ASSERT function to provide a specific error message, such as "Quantity must be an even number because these items are sold in pairs".

Alternating Workflow Paths (A/B Routing)

You can use ISEVEN in a Conditional Branch step to distribute approval runs between different paths based on the system-generated Run Number.

  • Scenario: To balance the workload, you want to send every second request to a specific "Auditor B" instead of the standard "Auditor A."
  • Formula: ISEVEN(@prop.RunNumber)
  • Logic:
    • @prop.RunNumber: This system property retrieves the sequential number assigned to the specific approval run (e.g., 1042).
    • Evaluation: If the current Run Number is 1042, the function returns TRUE, and the workflow follows the path for Auditor B. If the Run Number is 1043, it returns FALSE, and the system moves to the next valid path.