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.