different values for each repeating value

[claudiunemes]

Hello there,

I wonder if anyone could help me.

I have 2 fields with repeating values for 4 years of studies divided in 8 semesters (2 semesters by year).

One represent the

semester with 8 repeating values (semester[1], … semester[8])

and the other one represents the

year with 4 repeating values (year[1], … year[4])

What I want is that

in the first repeating value of the year to have

year[1] = Average (semester[1] ; semester[2])

in the second repeating value of the year to have

year[2] = Average (semester[3] ; semester[4]);

in the third repeating value of the year to have

year[3] = Average (semester[5] ; semester[6]);

and in the fourth repeating value of the year to have

year[4] = Average (semester[7] ; semester[8]);

Now I do this with 4 separate calculation fields with one repetition called year1 to year4, but I’m looking for a much more elegant solution as the one descripted above with one semester field with 8 repetitions and one year field with 4 repetitions instead of what I have now 1 semester field with 8 repetitions and 4 year fields with 1 repetitions each.

Many thanks for your time,

Yours,

Claudiu Nemes

netlogiq_claudiu(at)yahoo.co.uk