Compare Two Numeric Values

Choose two number fields or build two numeric expressions. Then, select how you will compare them to each other. If the comparison is true, the evaluation will pass. If the comparison is false, the evaluation will fail.


Evaluations have two automation triggers associated with them : Then and Else. Actions under the “Then” automation trigger execute when the evaluation passes, and actions under the “Else” automation execute when the evaluations fails.

Numeric comparison evaluations are used to execute a set of actions if two numeric values compare successfully, and another set of actions if they do not. If a non-numeric value returns from an expression on either side the evaluation will fail.

Example : Suppose an application contains a table for Contacts with a Annual Salary field and a Tax Bracket field. When the value in the Annual Salary field changes, the Contacts' Tax Bracket field needs to be updated appropriately. A builder would create a series of numeric comparison actions under a field changed evaluation on the Annual Salary field and under the appropriate automation triggers add set field value actions to update the Tax Bracket field.


Choose a field or build an expression

Choose a field or build an expression to be compared.

Choose how to compare them

Choose how these two expressions will be compared to one another. The available options are limited to those that should be used to compare numbers.

Choose a field or build an expression

Choose another field or build another expression to be compared.

Describe this action

Useful as a comment, this description will overwrite the automatically generated description in the Action Manager.

Queue this action and children

When an action is queued, the subsequent actions continue to process without it. Meanwhile, the queued action and its children process separately. Queue actions that you don't want a user to wait for.

action type - compare numbers.txt · Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2020