2 Replies Latest reply on May 14, 2010 7:29 AM by Woodzie

    Total Sub Summary based on absence of data in a field

    Woodzie

      Title

      Total Sub Summary based on absence of data in a field

      Post

      Hi, I'm a relative newbie, but learning fast...

       

      My data base tracks the deployment of police officers on peacekeeping missions. I've developed a report (using sub summaries) that lists the mission by acronym (e.g. UNAMID) then a sub summary for gender to show the number of male/female officers deployed to each mission. It looks like this

       

      AMISOM                **This is my first sub summary by Mission Acronym**

      Male: 1                  **This is my second summary by Gender. Code is <<Gender>> <<Count of Universal ID#>>

      Female: 3

       

      UNAMID

      Male: 4

      Female: 3

       

      Grand Total: 5     *Grand total currently does not equal the total of numbers above because some officers have been on several missions, or one mission several times.

       

       

      Challenge: The sub summary for gender includes officers that have returned from mission. I need to report only on those officers who are still on mission and do NOT have a date of return (i.e. an empty date of return field). 

       

      At the bottom of the report is a Grand Total Summary that must also exclude officers who have returned from mission.

       

      Any help is appreciated. 

       

      Filemaker Pro 11 on Windows XP

       

      w.