Basic Overview

Description

Extends the MULTIPLICATION (*) function with additional validation options.

It produces the same result as using 'NodeLeft' * 'NodeRight' if the validation passes.
In case the validation fails it produces an error with detailed explanation.

Signature

MULTIPLY(Node1, Node2 , [Validation])

Parameters

  • Node1: First factor node, specified using the node name in single quotes (e.g. 'Volume')

  • Node2: Node2: Second factor node, specified using the node name in single quotes (e.g. 'Price')

  • Validation: additional validations

Validation options

  • NoValidation: behaves exactly as MULTIPLICATION (*). The default option if no validation is specified.

  • FailOnMissingFirst: The calculation fails if any row in Node1 is not matched with any row in Node2.

  • FailOnMissingSecond: The calculation fails if any row in Node2 is not matched with any row in Node1.

  • FailOnMissing: Combines FailOnMissingFirst and FailOnMissingFirst validation options.

Warning: Using validation has performance impact.

Available since

3.9.0

Example

Node1 = 

YearMeasure
20186
20194
202010

Node2 = 

YearMeasure
20172
20183
20191



Node1 * Node2 = MULTIPLY(Node1, Node2) = MULTIPLY(Node1, Node2, "NoValidation")

YearMeasure
2017NaN * 2 = 0
20186 * 3 = 18
20194 * 1 = 4
202010 * NaN = 0

MULTIPLY(Node1, Node2, "FailOnMissingFirst") = 

Error, because year 2020 from Node1 has no matching value in Node2.

MULTIPLY(Node1, Node2, "FailOnMissingSecond") = 

Error, because year 2017 from Node2 has no matching value in Node1.

MULTIPLY(Node1, Node2, "FailOnMissing") = 

Error, because year 2020 from Node1 has no matching value in Node2 and year 2017 from Node2 has no matching value in Node1.