5 Replies Latest reply on Mar 23, 2009 4:35 PM by philmodjunk

    Calculate the number of occurrences of specific text value over several fields

    zifbox

      Title

      Calculate the number of occurrences of specific text value over several fields

      Post

      Hello, 

      I'm using Filemaker Pro 9.

      I have a table that has the names of up to four different people (each person entered in a separate field). Next to each name I have a set of radio buttons to select gender, Male or Female (M or F).

      I need two fields at the bottom, one calculating the total number of  males (M) on the form, and one calculating the total number of Females (F).

       

      I am so far unable to find a way of doing this efficiently.

       

      Can anyone help?

        

      thanks