How to count "active" repetitions

[Jarvis]

I have a text field with 10 repetitions.

In some records all of the repetitions are populated with a value.

In some of the records only a few of them are populated.

[color:red]Is there a way to keep count how many of the repetitions are populated?

Thanks for any suggestions,

Jarvis

[Søren Dyhr]

Hopefully do you not ignore the omnipresence of warnings against the utilization of repeaters as such??

http://www.briandunning.com/cf/287

--sd

[Tim W]

Hi,

The use of repeating fields for data storage is not recommended. This course of action will eventually lead to problems.

However I do believe a calculation will do the thing you require. Make the calculation unstored so it will calculate each time the record is accessed.

occupiedreps = Sum(

(not IsEmpty(GetRepetition(yourfield;1)+

(not IsEmpty(GetRepetition(yourfield;2)+

(not IsEmpty(GetRepetition(yourfield;3)+

(not IsEmpty(GetRepetition(yourfield;4)+

(not IsEmpty(GetRepetition(yourfield;5)+

(not IsEmpty(GetRepetition(yourfield;6)+

(not IsEmpty(GetRepetition(yourfield;7)+

(not IsEmpty(GetRepetition(yourfield;8)+

(not IsEmpty(GetRepetition(yourfield;9)+

(not IsEmpty(GetRepetition(yourfield;10))

Should total all non empty repeats.

HTH

Tim

[Raybaudi]

Why ? the Count ( ) function doesn't work ?

Something like:

Count( YourRepeatingField )

[comment]

Nah, too simple... :chili:

[Tim W]

So easy it just might work! :tigger: