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 | |
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
|
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 | |