Mult

Syntax

Mult(Parameters: Array)

Parameters

Parameters. Variables, the product of which is necessary to be found.

Description

It returns the product of corresponding points for two or more variables.

Comments

Variables in Parameters must be specified via comma.

The method provides a possibility to set calculation period. To do this, use the SetPeriod method, 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:

Example

Formula Result Application
= Mult({Brazil|BCA}, {China|BCA}, {Sudan|BCA})

Multiply corresponding observations of the Brazil|BCA, China|BCA and Sudan|BCA series.

It can be used in formulas of calculated series of time series database and in formulas of attribute-based models of modeling container.
= Mult(X1,X2,False)

The product of corresponding points of the X1 and X2 factors.

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

40

it can be used in any expressions.

See also:

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