AnsweredAssumed Answered

One date range, two subsummary fields

Question asked by bnuttman on Oct 15, 2012
Latest reply on Oct 15, 2012 by 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?

Outcomes