Hi,

I need help trying to create an elegant solution to this problem.

I need to do a "CountIf" type summary, counting all related records to the current one (which are also shown in a portal).

 

I have an Assignments table (each record has a unique AsnID) and an Individual Submission table with many records (each tied to the Assignment record through the AsnID).  A one:many relationship.  The important field here is that each Individual Submission has a field "Rating" that only allows "A", "B" or "C" values.  I'm sure you can see where this is going.

 

Is there are way that I can have a calculation field in "Assignments" that will count how many "A"s there are in all the related records' "Rating" field?  (I'll need three of them, one to count As, one to count Bs, and one to count Cs, but I can work that out if someone can show me how to do one of them).

 

In the main layout in which I'll be using this information, there's also a portal showing all the related records, so if it uses the portal to do this calculation, that's fine, but I'm sure it's possible without it.

 

This seems like a pretty simple thing to do, but I can't work it out and I can't find the answer through Google either.

Add a calculation field A_key = "A" to the Assignments table.  Add Assignments::A_key = Submission::Rating to the relationship to a TO of Submissions named A_sub.  Then a calculation field Assignments::A_count = Count(A_sub::ID) will show the count.

 

Repeat for the other ratings.

Another idea ... using same original entity relationship, calculation in Assignments:

PatternCount ( List ( Submission::Rating ; "A" ) )