4 Replies Latest reply on Oct 15, 2012 1:31 PM by bnuttman

    One date range, two subsummary fields

    bnuttman

      I want to do a report on people who entered my facility within a date range, for example from 1/1/2012...12/31/2012 (or any range of dates) and subtotaled by month.

      Everyone has an Entry Date and an Exit Date.

       

      For example:

       

      Month # Entered

      Jan 2012 23

      Feb 2012 21

      Mar 2012 32

      etc.

      I can do this report with a script that does a find with a global start and end dates such as:

      Enter Find Mode[]

      Set Field [EntryDate;g_date_start & “...” & g_date_end]

      Perform Find[]

      Then can do a subsummary by Month (Year (EntryDate) & Right("0" & Month(EntryDate);2)

      and it all works fine.

       

      What I want to be able to do is to get the number of people who exited the faciltiy on this same report for the same date range. For Ex:

      Month # Entered #Exited

      Jan 2012 23 16

      Feb 2012 21 22

      Mar 2012 32 24

       

      I can't seem to figure this out. Is it possible?