Doing a Summary of Repeating Fields

[vickyc]

Hello ! I am using some repeating fields (I know it is not the best, but It makes what I need to do much, much clear to work with), and I need to average all the "First repetition" together, all the second ones, and so on, like doing a summary of each one.

I don't know how I can do a Summary of repetition fields that is a repetition, too. and if it is not possible, do you know how can I do it?

Let me now ! I'll be very greatfull with you help..

Thanks,

Vicky

[Søren Dyhr]

Learn how to make relations work ...repeaters are wrong choise here! And very much to your luck did you discover it right away - congratulations!!!

Repeaters have their use, but it's more in tasks as display utilities and the building of complex keys!!!

--sd

[transpower]

A summary field which is the average of the repeating_field, in which repetitions are summarized individually.

[vickyc]

That's what I tried, but the summary fields didn't give me the chice to make it a field with repetitions ... Am I doing something wrong?

[transpower]

It's got to be a repeating field, because how could it summarize the repetitions individually otherwise?

[Ender]

I'm not sure what transpower is suggesting, but summary fields can't summarize specific repetitions, they summarize all repetitions containing data.

You would have to extract each repetition into a separate field and summarize that. Unfortunately, this is about as much work as using individual fields in the first place.

[-Queue-]

Transpower is referring to version 7's capabilities which don't seem to apply to the poster, who is using version 6.