Functions CumulativeAmount and CumulativeTotal
Functions are used in the formulas for calculating the rate and amount of the Salary Types, as well as in the calculated columns of the Settlements.
CumulativeAmount(Salary type number)
| Returned type | Number |
| Context | Salary types |
| Parameters | Type | Description |
| Type number | Text | Salary type number |
| Description | The sum of the amounts of the type of salary of the previous salary forms. |
| Example |
CumulativeAmount(1218.00) returns the sum of the amounts of the salary type 1218.00 from the previous salary forms of the employee. |
| Notice |
The current salary form is not taken into account when calculating. The parameter should not be the one of the salary type that uses this formula. |
CumulativeTotal(Salary type number)
| Returned type | Number |
| Context | Salary types |
| Parameters | Type | Description |
| Type number | Text | Salary type number |
| Description | The sum of the amounts of the type of salary of the previous salary forms. |
| Example |
CumulativeTotal(1218.00) returns the sum of the amounts of the salary type 1218.00 from the previous salary forms of the employee. |
| Notice |
The current salary form is not taken into account when calculating. The parameter should not be the one of the salary type that uses this formula. |
Français
Deutsch
Italiano