Operators in formulas
The formulas for calculating the rate and amount of the Salary Types as well as in the calculated columns of the Settlements, can contain different operators:
Operator =
| Type returned | Boolean |
| Context | Salary types, Settlements |
| Description | 1 if the numbers (or the results of the formulas) to the left and right of the operator are equal, otherwise 0. |
| Example |
MonthOf(DateValueSalary)=12 returns 1 when you enter salary records in December. |
Operator >
| Type returned | Boolean |
| Context | Salary types, Settlements |
| Description | 1 if the left number (or the result of the formula) is strictly greater than the right one, otherwise 0. |
| Example |
1>1 returns 0. |
Operator ≥
| Type returned | Boolean |
| Context | Salary types, Settlements |
| Description | 1 if the number (or the result of the formula) on the left is greater than or equal to the one on the right, otherwise 0. |
| Example |
1≥1 returns 1. |
Operator <
| Type returned | Boolean |
| Context | Salary types, Settlements |
| Description | 1 if the number (or the result of the formula) on the left is strictly less than the one on the right, otherwise 0. |
| Example |
1<2 returns 1. |
Operator ≤
| Type returned | Boolean |
| Context | Salary types, Settlements |
| Description | 1 if the number (or the result of the formula) on the left is less than or equal to the one on the right, otherwise 0. |
| Example |
1≤2 returns 1. |
Operator +
| Type returned | Number |
| Context | Salary types, Settlements |
| Description | Addition |
Opérateur -
| Type returned | Number |
| Context | Salary types, Settlements |
| Description | Subtraction |
Operator *
| Type returned | Number |
| Context | Salary types, Settlements |
| Description | Multiplication |
Operator /
| Type returned | Number |
| Context | Salary types, Settlements |
| Description | Division |
Français
Deutsch
Italiano