value list totals with repeating fields

[blomgren]

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!

[jscooper]

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

[Vaughan]

Much better to ditch the repeating fields and go to a related file. Then everything will be easy-peasy.

[blomgren]

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?

[blomgren]

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

[Vaughan]

You could probably simplify even more and make one "grade" database and have a field in it that selects grade 1 or 2.