Functions Table and TableColumn
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.
Table(code;number)
| Type returned | Number |
| Context | Salary types, Settlements |
| Parameters | Type | Description |
| code | Text |
Table code number |
| number | Formula or Number |
Value to find in the table |
| Description |
A value from the table, corresponding to the interval that encompasses the number passed as a parameter. |
||||||||||||||||
| Example |
Table(PREMIUM "Special premium";DaysSeniority(2)/360) returns 100 for an employee with 25 years of service with the following table:
|
TableColumn(code;number;column)
| Type returned | Number |
| Context | Salary types, Settlements |
| Parameters | Type | Description |
| code | Text |
Table code number |
| number | Formula or Number |
Value to find in the table |
| column | Formula or Number |
Table column number |
| Description |
A value from the table, in the specified column, that falls within the range of the number passed as a parameter. |
| Notice |
The endpoints of the interval are included in the search. |
| Example |
TableColumn(ISVD "Impôt source Vaud 2027";ValueBase(7 "Gross Total");EmployeeCustomNumber1) searches the ISVD table for the interval corresponding to the value of the base 7, which totals the types of salary subject to withholding tax, and returns the value of the column whose number is equal to that of the Custom Number1 field of the employee record. |
Français
Deutsch
Italiano