Previous | Next | Contents | Index | Navigation | Glossary | Library |
No. | Condition | Database Item | Operator | Value/ Database Item |
---|---|---|---|---|
10 | &SALARY_PAY_VALUE_ENTRY_VALUE | >= | 16000 | |
20 | AND | &SALARY_PAY_VALUE_ENTRY_VALUE | <= | 24000 |
Table 1 - 18. Assignment Set Criteria |
Note: The list of assignments you see in this window is either all the assignments in the Business Group or, if you selected a payroll, all the assignments to that payroll. It does not show the assignments matching your criteria since these are identified dynamically each time the formula runs.
Operator | Symbols | Meaning |
---|---|---|
Equals | = | The condition is true if both expressions have exactly the same value. For text, the case of the expression must be the same. So, for example, 'Smith' is not equal to 'SMITH'. |
Not Equal | != | The condition is true if the result of the first expression does NOT have the same value as the result of the second expression. |
Greater than | > | The condition is true if the first expression is alphabetically after, or has a numerically greater value, or a later date than the second expression. |
Less than | < | The condition is true if the first expression is alphabetically before, or has a numerically smaller value, or an earlier date than the second expression. |
Greater than or equal to | >= | The condition is true if either the greater than OR the equal to operator returns a true result. |
Less than or equal to | <= | The condition is true if either the less than OR the equal to operator returns a true result. |
Table 1 - 19. Values in Operator Field |
Attention: Do not create a mixture of Include and Exclude rows if you have not entered criteria and generated a formula.
Previous | Next | Contents | Index | Navigation | Glossary | Library |