Can we create a expression with counter ?

[chiru_thota]

Hi all,

Can I get the below expression as highlighted in red.

Basically I am trying to start my counter at 1 and continue till I see null.....same thing repeats but it should from 1 again continue (1,2,3...).

Is this possible some how ?

[chiru_thota]

Any Ideas ?

[jonathandienst · Accepted solution]

Hi

Counter:

=If(IsNull(Above([Value])), 1, Above([Counter]) + 1)

or

=If(IsNull([Value]), null(), If(IsNull(Above([Value])), 1, Above([Counter]) + 1))

HTH

Jonathan

[chiru_thota]

Thanks Jonathan.

You are real guru!

Thanks,

Chiru