Count of Open Status

[mdelgado100]

am working in Crystal Report (8.5)using an Oracle Database.

My issue is that I need to have a count of ticket in Open status during a selected PAST date range. (FDATE) to (FTDate)

The Closed Status is triggered when a Closed time is registered. Changing the status from Open to Closed.

In order to know what WAS in open status in the PAST, I would have to write a formula asking What was open during a period of time:

1)tickets remained without a closed date.

This is what I have...it doesn't work.

if {.Close Date & Time} > {?FTDate}
then
1
else 0

Please help...Maria

 

[IdoMillet]

If you SUM (Note: not Count) that formula, you would get a count of how many records answered the condition.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com