MULTIPLICATION (*)

'Node1' * 'Node2'

In Arithmetic operators

The MULTIPLICATION operator multiplies two inputs across their combined dimension set. In other words, multiplication uses the union of both inputs’ dimensions.

The result keeps the finer level in each shared dimension and retains dimensions that exist on only one side.

Use this operator for standard multiplication without additional validation handling: 'Volume' * 'Price'.

Parameters

Node1Node referenceRequired
First factor node, specified using the node name in single quotes (e.g.'Volume')
Node2Node referenceRequired
Second factor node, specified using the node name in single quotes (e.g.'Price')

Output shape

Dimensionality
The result uses the combined dimension set (the union of both inputs’ dimensions). Per shared dimension, the finer level is used. Dimensions that exist on only one side are kept as-is.
Level values
Values are matched on shared dimensions. Non-shared dimensions expand the result across matching rows.
Row count
Equal or expanded.

Watch out

  • Multiplication uses the combined dimension set (union), not the common dimensions. This is the opposite of addition and subtraction.
  • If one input has additional dimensions, the result expands to keep them.
  • This expansion is a common cause of unexpected output shape.
  • Units are multiplied together as well. For example, EUR * Quantity produces the combined unit EUR * Quantity.

Examples

Multiplying nodes with matching dimensions

Input node: 'Node1'

YearValue
20252
20264

Input node: 'Node2'

YearValue
20253
20261

Formula: 'Node1' * 'Node2'

YearCalculationResult
20252 × 36
20264 × 14

Multiplying nodes with some shared dimensions

This example shows how multiplication keeps the finer dimensionality from Node2.

Input node: 'Node1'

YearValue
20252
20264

Input node: 'Node2'

YearProductValue
2025A2
2025B0
2026A1
2026B4

Formula: 'Node1' * 'Node2'

YearProductCalculationResult
2025A2 × 24
2025B2 × 00
2026A4 × 14
2026B4 × 416

Multiplying by a scalar

When one input is a scalar value, that value is applied across all rows of the other input.

Input node: 'Node1'

YearValue
20252
20264

Input node: 'Node2'

Value
2

Formula: 'Node1' * 'Node2'

YearCalculationResult
20252 × 24
20264 × 28

See also

MULTIPLY
When you want multiplication with explicit validation options and clearer mismatch handling.
DIVISION (/)
When you want the same combined-dimension logic but need to divide instead of multiply.
Was this page helpful?