Jump to content

different values for each repeating value


This topic is 6085 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

This topic is 6085 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.