### Title

Need to count values in one calculation field

### Post

Hello all

I am in desperate need of a way to count how many -2's, -1's, 0's 1's 2's etc occupy one particular calculation field. I am tracking the academic progress of students at my school and have got a value for a particular criteria (let's say reading skills) for a particular time of school (for year one during term 2 each student should be at level 5) I have been able to create a calculation field to determine whether or not a student is below, at or above agreed level but I want to graph that number dynamically according to whatever group is selected (all the boys in grade 2, all of grade 1 etc)

Any help would be greatly appreciated.

PeterJ

You'll need to describe your data model, the tables and relationships used. What you describe is possible but the devil is in the details you have not yet shared about your project.

The version of FileMaker that you are using is also important.

Summary reports, relationships, filtered portals and ExecuteSQL (if using version 12 or newer) could all be used to produce such a count. And this is also data that can be charted from either a found set or possibly a set of related records.