MaxI(Inputs: Array)
Inputs. Variable.
It returns the maximum value among variable points if it contains integer values only.
If more than one variable is specified in Inputs, then maximum value of corresponding variable points will be calculated. For example, maximum number of points for 2018 by all variables.
The variables in Inputs must be specified via comma.
It is available to set up calculation period for function. To do it, use the SetPeriod function by specifying it at any place of input array.
To calculate function without taking into account empty values, use the IgnoreMissing parameter by specifying it at any place of input array. Available parameter values:
True. Default value. Calculation does not take into account empty values
False. Calculation takes into account empty values.
To get maximum variable number that contains not only integer values, use the Max function.
| Formula | Result | Application |
| = MaxI({Brazil|BCA}, SetPeriod(2000,2010)) | Maximum value of the Brazil|BCA series observations for the period from 2000 to 2010. If any series contains real values, the error appears. |
It can be used in formulas of calculated series of time series database and in formulas of attribute-based models of modeling container. |
| = MaxI(False, X1, X2) | Maximum value of corresponding points of the X1 and X2 factors taking into account empty values. |
It can be used in model variable-based formulas of modeling container. |
| = Max(1, 2, 3, 4) | 4 |
it can be used in any expressions. |
See also:
Functions Available in Expression Editor │ Arithmetic Functions │ IModelling.MaxI