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 |