DIVIDE

Basic Overview

Description	Extends the DIVISION (/) 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	DIVIDE(Node1, Node2 , [Validation])
Parameters	Node1: Dividend node, specified using the node name in single quotes (e.g. 'Profit') Node2: Divisor node, specified using the node name in single quotes (e.g. 'Profit') Validation: additional validations
Validation options	NoValidation: behaves exactly as DIVISION (/). 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.

Node1 =

Node2 =

Node1 / Node2 = DIVIDE(Node1, Node2) = DIVIDE(Node1, Node2, "NoValidation")

DIVIDE(Node1, Node2, "FailOnMissingFirst") =

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

DIVIDE(Node1, Node2, "FailOnMissingSecond") =

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

DIVIDE(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.