Hi everybody.
Is there any way to obtain a number corresponding to the fields with
data in a repetition field?
For example, if I have a repetition field with 10 repetition fields but
I have data (information) in the first three, I would like to have the
value "3", if I have 5 out of 10, I would like to obtain the value "5".
I cannot find any function for that.
Thanks,
Jokin

This is a more complex question than it seems.

If you are just trying to figure out how many values are in the repeating
field, you can use the Count() function. However, this will not care whether
the values are in repetitions 1,2,4 or 1,3,5 or 2,4,5.

If you are trying to determine which repetitions are being used and which
are empty, then the surest way is to use Get(CalculationRepetitionNumber).
For example, create a calculation field, "WhichRep" with the following
formula:

If(not IsEmpty(X);Get(CalculationRepetitionNumber);"")

Where X is the repeating field you're trying to analyze. Make sure you also
specify that the calculation repeats as much as X does. and then,

List(WhichRep) in a new calc field returns all those values into a single
field. But you may not need this second calc field, depending on how you're
going to use the info.

"Jokin" <joaquin.castilla (AT) gmail (DOT) com> wrote

Jokin also might want to consider if a repeating field is the most
appropriate way to stare his data. He didn't give enough background, but
setting this one up using a relation might be easier.

Ursus


"Bill Marriott" <wjm (AT) wjm (DOT) org> schreef in bericht
news:E-GdnRApqeYfH_DYnZ2dnUVZ_tidnZ2d (AT) comcast (DOT) com...

Count () is working perfect.
Thank you
Jokin

On Nov 29, 7:14 am, "Jokin" <joaquin.casti... (AT) gmail (DOT) com> wrote: