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. 

Signature  MULTIPLY(Node1, Node2 , [Validation]) 
Parameters 

Validation options 
Warning: Using validation has performance impact. 
Example
Node1 =
Year  Measure 

2018  6 
2019  4 
2020  10 
Node2 =
Year  Measure 

2017  2 
2018  3 
2019  1 
Node1 * Node2 = MULTIPLY(Node1, Node2) = MULTIPLY(Node1, Node2, "NoValidation")
Year  Measure 

2017  NaN * 2 = 0 
2018  6 * 3 = 18 
2019  4 * 1 = 4 
2020  10 * NaN = 0 
MULTIPLY(Node1, Node2, "FailOnMissingFirst") =
Error, because year 2020 from Node1 has no matching value in Node2.
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.
MULTIPLY(Node1, Node2, "FailOnMissingSecond") =
Error, because year 2017 from Node2 has no matching value in Node1.