Custom Calculation Formula Needed

[paulh77730136]

I have 31 text boxes, one for each day of the month.  In each text box there are 5 or 6 different entries, such as P, T, AB, AT.  I want to create a field to total the P's and T's but not the AB's and AT's.  How do I do that?

[try67]

What are the names of those fields?

[paulh77730136]

Smith 1 through Smith 31

[try67 · Accepted solution]

OK, then you can use this code as the custom calculation script of the total field:

var total = 0;
for (var i=1; i<=31; i++) {
    var v = this.getField("Smith "+ i).valueAsString;
    if (v=="P" || v=="T") total++;
}
event.value = total;

Edit: Forgot to add a space after "Smith"...

[paulh77730136]

That worked.  Thanks try67.  You are a rock star!!