Functions ColumnAmount, ColumnRate and ColumnTotal
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.
ColumnAmount(Salary type number 1[;Salary type number 2]…)
| Returned type | Numerical |
| Context | Settlements |
| Parameters | Type | Description |
| Salary type number | Text | Salary type number |
| Description | Column amount. |
| Example |
ColumnAmount(6001.00) returns the number of kilometers traveled. |
| Notice |
You can enter a list of salary types. For instance : |
ColumnRate(Salary type number 1[;Salary type number 2]…)
| Returned type | Numerical |
| Context | Settlements |
| Parameters | Type | Description |
| Salary type number | Text | Salary type number |
| Description | Column rate. |
| Example |
ColumnRate(1004.14)/NbSalary returns the number of hours of paid absence on average per pay slip |
| Notice |
It is possible to specify a list of salary types (see ColumnAmount). |
ColumnTotal(Salary type number 1[;Salary type number 2]…)
| Returned type | Numerical |
| Context | Settlements |
| Parameters | Type | Description |
| Salary type number | Text | Salary type number |
| Description | Column total. |
| Example |
ColumnTotal(1055.00) returns the total reimbursed as travel expenses. |
| Notice |
You can enter a list of salary types (see ColumnAmount). |
Français
Deutsch
Italiano