FINDFIRST

In Filtering & data shaping

The FINDFIRST function returns the first defined value per group along a given level. If no level is given, the function automatically uses the lowest level in the time dimension used by the node.

Use this function when you need to select one representative value per group, for example the first entry per product or the starting value in a time series.

It is often paired with TRUE to generate starting values, for example with SCHEDULEPROJECTS: TRUE(FINDFIRST('Node')).

Parameters

NodeNode referenceRequired

Input node.

LevelLevel nameOptional

The name of the level to find the first values in respect to. Defaults to the lowest time level on the node.

Watch out

Example

First value per product along the time dimension

This example returns only the earliest defined value for each product. Products with gaps retain only the first year’s value.

Input node: 'Node A'

Formula: FINDFIRST('Node A')

Equivalent to: FINDFIRST('Node A', "Year")

See also

ENUM

When you want an index or ordering helper based on measure values rather than selecting one value per group.

ENUM_LEVEL

When you want an index based on the order of level values in dimension management rather than selecting one value per group.