Help with calculating fields with text entries

[phtmb]

Need some help with some calculations: If I have a recreation league that has 15 sports, each of which is a field. Determining which of those sports has been rebooked for this year, the entry for each of those those fields (sports) is either Yes, No, or N/A. If I have rebooked 6 sports( 6 fields containing Yes), have 8 sports to rebook (8 fields containing No) and one sport not participating (1 field marked N/A), what fields do I need to create to show the percentage of sports which have been rebooked for that particular league. In the example 6 of 14 have been rebooked for a percentage of 43% rebooked. I guess the basic question is how do I calculate the number of

[rpoelking]

The question is, are you trying to determin the rebooked % of sport 1 over a number of records (leaugues?) or the rebooked % for sports 1-15 for a record (1 league)?

Case 1

Patterncount (Sport1, "Yes") / Status(currentfoundcount)

Case 2

Patterncount (Sport1 & Sport2 & ... & Sport15, "Yes") / 15

I might have misunderstood what you were asking, but I hope this answers your question. The same formulas can be applied for "No" and "N/A"

[phtmb]

It was case 2 and your suggestion worked perfectly. Thank you so much!