Sequential numbering according to criteria

Danilo_Correa · February 13, 2020, 8:05pm

Hi,

I`m trying to show a sequential numbering according to an specific criteria to each entry inside a repeat group, like this:

'1 - 0 meter'
'2 - 0.5 meters'
'3 - 1 meters'
'4 - 1.5 meters'
'5 - 2 meters'

and so on.

The main goal is to help the data collector according to a spatial reference.

For each entry ODK already shows a sequential integer (1, 2, 3...).

Need a way to calculate and show the sequence shown above.

Thanks in advance!

Grzesiek2010 · February 14, 2020, 9:50am

do you want it to have in one group or maybe
'1 - 0 meter' - is group no. 1
'2 - 0.5 meters' is in group no 2 etc

Danilo_Correa · February 14, 2020, 12:49pm

Exactly:

'1 - 0 meter' - is group nº 1
'2 - 0.5 meters' is in group nº 2
'3 - 1 meters' is in group nº 3
etc

PS: i've introduced myself at the intro topic

Grzesiek2010 · February 15, 2020, 11:50am

So you can calculate it using position(..) func.
Here is a sample: calcTest.xlsx (6.5 KB)