Functions SalaryPreviousAmount, SalaryPreviousRate and PreviousSalary
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.
SalaryPreviousAmount(salary type number)
| Type returned | Number |
| Context | Salary types |
| Parameters | Type | Description |
| salary type number | Text |
Number of the salary type |
| Description |
The salary amount. |
| Example |
SalaryPreviousAmount(1000.00) returns 4800 in the March 2027 salary record if the number 1000.00 corresponds to the salary type “Monthly salary” and the monthly salary for February 2027 is 4,800 CHF. |
SalaryPreviousRate(salary type number)
| Type returned | Number |
| Context | Salary types |
| Parameters | Type | Description |
| salary type number | Text |
Number of the salary type |
| Description |
The salary rate. |
| Example |
SalaryPreviousRate(5060.30) returns 0.12 in the March 2027 salary record if the number 5060.30 corresponds to the salary type “Source tax as a percentage” and the February 2027 salary withheld a tax rate of 12%. |
PreviousSalary(salary type number)
| Type returned | Number |
| Context | Salary types |
| Parameters | Type | Description |
| salary type number | Text |
Number of the salary type |
| Description |
The sum of the salary. |
| Example |
PreviousSalary(6800.60) returns 15 in the March 2027 salary record if the total of the 6800.60 pay type (“Remaining Vac. Days”) of the February 2027 salary record contains 15. |
Français
Deutsch
Italiano