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. 

Signature  FINDMISSING(Node 1, Node 2 [, Behavior]) 
Parameters 

Limitations 

Example
Inputs:
Node A
Year  Product  Volume 

2021  Alpha  10 
2021  Blade  5 
2021  Droplet  7 
2022  Alpha  12 
2022  Blade  6 
2022  Droplet  9 
Node B
Product  Price 

Alpha  55 
Blade  65 
Gamma  80 
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.
Year  Product  Measure 

2021  Alpha  0 
2021  Blade  0 
2021  Droplet  1 
2022  Alpha  0 
2022  Blade  0 
2022  Droplet  1 
FINDMISSING('Node A', 'Node B', SECOND)
Product  Measure 

Alpha  0 
Blade  0 
Gamma  1 
FINDMISSING('Node A', 'Node C', BOTH)
Year  Product  Measure 

2021  Alpha  0 
2021  Blade  1 
2021  Droplet  1 
2021  Gamma  1 
2022  Alpha  1 
2022  Blade  1 
2022  Droplet  1 