Function NbKids
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.
NbKids(min age;max age[;category])
| Type returned | Number |
| Context | Salary types, Settlements |
| Parameters | Type | Description |
| min age | Number |
minimal age |
| max age | Number |
maximal age |
| category | Text |
Category to compare |
| Description |
Number of children older than or of the same age as the minimum age specified and younger than the maximum age specified. If the category is specified, only children in that category are counted. |
| Example |
NbKids(0;17;Student) returns 2 if the employee has 3 children, of which 2 are under 18 years of age and are in the Student category. |
Français
Deutsch
Italiano