Basic Overview

AVAILABLE SINCE 5.6.0

Description

The FINDFIRST function is used to find the first values in a table in respect to a given level. If no level is given the function will automatically use the lowest level in the time dimension used by the node.

Signature

FINDFIRST(Node[, Level])

Parameters

  • Node: Input node

  • Level: The name of the level to find the first values in respect to (see limitations for values allowed)

Limitations

If any of the following limits are not followed, an error will occur:

  • If no level is provided and the node does not use the time dimension

  • The inputted level must be used by the entered node

  • The level to find can not be higher in the dimension than the level used in the node

    • E.g. if the node uses ‘Month’ the inputted level can not be ‘Year’

Example

Input:

Node A

2016

2017

2018

2019

Product A

4,5

4,5

4,5

Product B

5

6

6,4

Product C

7

Product D

5,6

5,6

To find the year each product has its first entry in the table the following configuration of the function would be used:

FINDFIRST('Node A') = FINDFIRST('Node A', “Year”)

Result:

2016

2017

2018

2019

Product A

4,5

Product B

5

Product C

7

Product D

5,6