Skip to main content
Skip table of contents

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. 

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.