Portal counting

[agaperrk]

I have a Relationship between two tables. I created a portal. In this portal I need a calculation field that will count Only fields in it that do not have the word "pilgrim" It can show in the portal but not be counted. Then I have another field that if that field has something in it. It will be counted.

Example

Class date pilgram "This Record would not Count"

class Speech date

Class Date

The next two would be counted, the speech field would need to be counted when ever something is in the field.

2 classes

1 Speech.

If I had more speeches then it would count them to. The Total would be displayed on the same layout as the portal.

Thanks in Advance

[bcooney]

I really don't follow...what are the tables, what is their relationship, what are the fields in each table. I do have a bad cold today, so it's probably me.

Anywho, you can create a calc field that uses the PatternCount function. If the fields (case statement) that you are monitoring have the key word, then this calc would equal 1. Then sum that field with a sum function (if from a parent) or a summary field.