SumI(Parameters: Array)
Parameters. The variables, which sum should be found.
It returns the sum of corresponding points for two or more variables if they contains integer values only.
Variables in Parameters 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.
Use the Sum method to calculate the sum of corresponding points for variables containing not only integer values.
Formula | Result | Application |
= SumI({Brazil|BCA},{China|BCA}, {Sudan|BCA})
|
Sum of corresponding observations of the Brazil|BCA, China|BCA and Sudan|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. |
= SumI(X1,X2,True) | Result: the sum of corresponding X1 and X2 factor points without taking into account empty points. |
It can be used in model variable-based formulas of modeling container. |
= SumI(4,2,5,-3) | 8 |
It can be used in any expressions. |
See also:
Functions Available in Expression Editor │ Transformations │ IModelling.SumI