FINDMISSING

Basic Overview

AVAILABLE SINCE 5.5.0

Description	The FINDMISSING formula is used to find missing values in your data while comparing two nodes against each other. Dependent on the ‘Behavior’ input, the function finds missing level values in either of the nodes. The shown result will contain '0' and '1' as values, marking the missing values with '1' and the existing values with '0'.
Signature	FINDMISSING(Node 1, Node 2 [, Behavior])
Parameters	Node 1: Input node Node 2: Input node Behavior: [optional] - indicates the leading node which is checked for missing values Could be one of the following values: FIRST (set as default) - the first node is checked for missing values SECOND - the second node is checked for missing values BOTH - checks the combined data of node 1 and node 2 for missing values
Limitations	In case the applied behavior is 'BOTH', all input must have the same dimensionality.

Inputs:

Node A

Node B

Node C

Year	Product	Volume
2021	Alpha	10
2021	Gamma	5

Results:

FINDMISSING('Node A', 'Node B') === FINDMISSING('Node A', 'Node B', FIRST)

As 'FIRST' is the default when entering no behavior, entering nothing and 'FIRST' shows the same result.

FINDMISSING('Node A', 'Node B', SECOND)

FINDMISSING('Node A', 'Node C', BOTH)