Skip to main content
Skip table of contents

MULTIPLY

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.



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.