Functions Maximum and Minimum
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.
Maximum(number 1[;number 2]…)
| Type returned | Number |
| Context | Salary Types, Settlements |
| Parameters | Type | Description |
| number | Formula or Number | Values to be evaluated |
| Description | The maximum value in the parameters. |
| Example |
Maximum(7;19;-5) returns 19. |
Minimum(number 1[;number 2]…)
| Type returned | Number |
| Context | Salary Types, Settlements |
| Parameters | Type | Description |
| number | Formula or Number | Values to be evaluated |
| Description | The minimum value in the parameters. |
| Example |
Minimum(8100;ValueBase(7 "Gross total")) returns 8100 or the minimum value of the Base number 7 if lower (value 8100 is then the maximum value returned). |
Français
Deutsch
Italiano