Multiply

aggregating category: arithmetic no `||`

Multiplies all values given to the rule, or all available inputs.

Multiplies all values supplied as parameters in order. If no parameters are given, all available inputs are multiplied. The output type is promoted to FLOAT if any input is a float; otherwise it is INT.

Parameters

1 — multiplier Optional — accepts: field, INT, FLOAT

The first value of the multiplication. May be a field reference or a static value.

N — multiplicands Optional — accepts: field, INT, FLOAT

The Nth multiplicand. May be a field reference or a static value.

Input type

• FLOAT
• INT

Output type

• matches-input-promotion

Returns FLOAT if any input is a float, otherwise INT.

Examples

Multiply all available inputs

Multiply()

Multiplier and two multiplicands

Multiply(:multiplier, :multiplicand1, :multiplicand2)

Static values

Multiply(10, 10, 10)

Mixed static and field

Multiply(4.2, :multiplicand)

See also

Add, Subtract, Divide