Hi Everyone,

i'm trying to replicate in Nexel the following excel formula:

**=MATCH(TRUE;INDEX((B2:B8>A2);0);0)**

The objective is to obtain the row number of a range where a condition is met for the first time.

In the example attached i'm looking to find in the range (B2:B6) the **first row** where the value is ">1000" (A2), so the 4th.

I can't find the right syntax and unfortunately the "Nexel formulae" doesn't help.

I'm working with Board version 10.1.2

Thank you,

Fabio

I couldnt get the MATCH or INDEX formulas to work, but i got what i think you are after in a different way.

3 Blocks in a layout.

Block A is the "Value"

Block B and C are algorithms with nexel.

Block B Nexel: =If([@a;*;*]>200,1,0)

Block C Nexel: =if(and(sum([@b;*;*;Range.Up])=1,[@b;*;*]=1),1,0)

Block C will put a "1" in the first row to meet criteria based on block B logic.

Unfortunately, while you can sort on the nexel columns by clicking on the block headers, you cannot sort/filter on them in the layout unless you write to a cube (which you can do if needed.)

HTH.