Could you split the Child IDs column and then add them together? The calc might look like:
COUNT(Child ID - Split 1) + COUNT(Child ID - Split 2) + COUNT(Child ID - Split 3) + COUNT(Child ID - Split 4)
I don't know how many potential children would be involved. If there were a lot, then this might not be a good solution.
Yes, that would work and I've done it that way. What I'd like to do though (and I probably should have said this more clearly) is to have another measure called 'Complete?' that's a yes or no. Then I'd take these yes or no's and determine a percent completion of each project based on the completion of the children. Hopefully this makes sense. What counting the children column misses is a way to actually search for data along each child row; it knows how many children there are but it doesn't know where they are in the table. Now if there was a way that I could count the entries in that column (I've alreaady figured that out) and then examine that many rows under the parent for complete yes/no, then that would work as the children are always directly under the parent.
If the table is setup as displayed, then you should be able to put this new calc into the view along with the field for Row ID to get a count per Row ID.
Did I miss something in the setup?