MAX ()
- Pedro Jose Sanchez Luling
MAX(value [, value, ...]) |
API Version | 2.7.27 and higher |
|---|
Calculates the maximum value of a list of values
Note that this function will calculate the maximum value depending on the type of values received:
If all the parameters are numeric, then a numeric comparison will be done. For example, MAX(“001”, “0002”) will return “0002”.
If any of the parameters is not numeric, then a string comparison will be performed. For example, MAX(“$“, “001”, “0002”) will return “001”.
Input Parameters
Execution
Always. Calculated on-the-fly whenever an ITEM of a FORM is changed (by means of form_set_answer(), or when the FORM is opened
Examples
Formula | Description |
|---|---|
| Result = 13 |
| Result = “0002” Note that as all the values are numeric, a numeric comparison is done |
| Result = “001” Note that as at least one parameter is not numeric, a string comparison is done |
| Result = 19 |