MinI

Syntax

MinI(Inputs: Array)

Parameters

Inputs. Variable.

Description

It returns the minimum value among the variable points if it contains integer values only.

Comments

If more than one variable is specified in Inputs, then minimum value of corresponding variable points will be calculated. For example, minimum value 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:

To get minimum value of variable containing not only integer values, use the Min function.

Example

Formula Result Application
= MinI({Brazil|BCA},{Peru|BCA})

Minimum value of corresponding observations of the Brazil|BCA and Peru|BCA series. If any of time series contains the real values, an 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.
= MinI(X1, SetPeriod(2000,2010), false)

Minimum value of the X1 factor name taking into account empty values from 2000 to 2010.

It can be used in model variable-based formulas of modeling container.
= MinI(1, 2, 3, 4)

1

it can be used in any expressions.

See also:

Functions Available in Expression Editor │ Arithmetic Functions │ IModelling.MinI