Need to calculate and store values

[Tenchi]

I have a database of students who are eligible to work and have been placed. I want to count the number of students who have been placed. The field "Academy Placement" is formatted as radio buttons, and uses the value list "Academy Placed" which contains the values "Yes" and "No". I want to count only those records where "Yes" has been selected for "Academy Placement", and then summarize them in the summary field "Year Placed". I created the calculation field Current_Placed to Count(Academy Placement), but it returns all the records, whether the value is "Yes" or "No".

I've tried IF and CASE functions, but I'm not sure if this the right path. How can I count only the "Yes" values?

[Kurt Knippel]

You could try Sum ( Academy Placement ) since Yes will equate to 1. However I do not like assuming such things. I would create a caluclated field (formatted as a NUMBER) such as:

code:

---

cPlaced = Academy Placement

---

This will cause all the values of Yes to be replaced with a 1. Then you can do the Sum ( cPlaced ) to get the total.