### Title

Calculation field to filter results...

### Post

Hello-

I need to make a calculation field that will filter a count of records. So if I have 2000 records of students and I want a count of only the records with the number 7 in the age field, how do I go about this without using a portal.

I have tried setting up a calculation field called KidCount wiht the following calc.: IF ( Age=7 ; Count (ChildNames))

I get no answer....

Any help would be appreciated...

It would help to know why a portal cannot be used for this.

This appears to be a classic "selective sum" or "sum If" question. There are a number of possible solutions, some use portals some don't.

Sum_Calculation based on condition

An option not mentioned in that thread is to use ExecuteSQL to selectively count your records.