Functions ValueSalaryType, ValueSalaryTypeAmount and ValueSalaryTypeRate
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.
ValueSalaryType(type number)
| Type returned | Number |
| Context | Salary types |
| Parameters | Type | Description |
| type number | Text |
Salary type number |
| Description |
The total of the indicated type of salary of the same salary record, only if this type of salary is already calculated. |
| Example |
(ValueSalaryType(1000.00)+ValueSalaryType(1005.10))*0.05 returns 300 if the number 1000.00 corresponds to the salary type “Monthly salary,” the number 1005.10 to the salary type “Overtime,” and This function allows, for example, to calculate an AHV-AVS amount without having to go through a base that groups the submitted amounts. The ValueBase function is however faster if the number of salary types is greater than 1. |
ValueSalaryTypeAmount(type number)
| Type returned | Number |
| Context | Salary types |
| Parameter | Type | Description |
| type number | Text |
Salary type number |
| Description |
Returns the Amount of the salary type indicated as a parameter, only if this salary type is already calculated (in the same salary record). |
ValueSalaryTypeRate(type number)
| Type returned | Number |
| Context | Salary types |
| Parameter | Type | Description |
| type number | Text |
Salary type number |
| Description |
Returns the Rate of the salary type indicated as a parameter, only if this salary type is already calculated (in the same salary record). |
Français
Deutsch
Italiano