Jump to content

value list totals with repeating fields


blomgren
 Share

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

Recommended Posts

I have several repeating fields [field1, field2, fiels3] repeating 5 times and all share a value list:

A

B

C

Can I total how many "A", how many "B", how many "C" and then total "A" & "C"?

I usually can find the answers just by browsing around here. Thanks!

Link to comment
Share on other sites

For each field, I would define repeating calculations for each value you want to check, then a non-repeating calculation counting values in the first field(s). There may be better methods if you have a bunch of values (so you don't have to define 100s of fields), but with only 3, this should work

is1A = if(Field1 = "A","Y",""), repeating w/ 5 repetitions

is1B = if(Field1 = "B","Y",""), repeating w/ 5 repetitions

is1C = if(Field1 = "C","Y",""), repeating w/ 5 repetitions

is2A = if(Field2 = "A","Y",""), repeating w/ 5 repetitions

is2B = if(Field2 = "B","Y",""), repeating w/ 5 repetitions

is2C = if(Field2 = "C","Y",""), repeating w/ 5 repetitions

is3A = if(Field3 = "A","Y",""), repeating w/ 5 repetitions

is3B = if(Field3 = "B","Y",""), repeating w/ 5 repetitions

is3C = if(Field3 = "C","Y",""), repeating w/ 5 repetitions

countA = count(is1A) + count(is2A) + count(is3A)

countB = count(is1B) + count(is2B) + count(is3B)

countC = count(is1C) + count(is2C) + count(is3C)

Jeff

Link to comment
Share on other sites

Well... actually I have about 44 fields (weeks of the school year) X 9 layouts (one for each grade level - K-8). I want to enter E-excused, U-unexcused, T-tardy into the repeating 5 fields (one for each day of the week). All was working well while I was just entering "1" for absent. I am not sure what you mean by ditching the repeating fields and creating another file?

Link to comment
Share on other sites

Vaughan, thank you so very much for the "easy-peasy" related files!!!! I just couldn't wrap my head around this idea... then! BAM!!! I don't have to make 185 fields X 9 class layouts! I just make one year layout and relate students to a Grade1 db, Grade2 db,... I have been struggling with this for sooooooooo long. I took on this job of creating a db for a school district that houses everything! and I am just a wayward housewife with too much time on my hands. This place is so great!

Trish

Link to comment
Share on other sites

This topic is 6565 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
 Share

×
×
  • Create New...

Important Information

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