Link to home
Start Free TrialLog in
Avatar of captgriggs1
captgriggs1

asked on

Response time <= 5.00 then 1 else 0

Hello,
I'm trying to get the number of days that a call was open, I keep getting 1 instead of the total which should be about "X" for the dates that I'm using.  The ClosedIn5 is what I'm working on.  I have included the fields that it uses.  Thanks!

Formula Fields

ClosedIn5
if {CallLog.CallStatus}='Closed' and {@Closed Date} in {?Begin Date} to {?End Date} and
{@ResponseTime} <= 5.00 then 1 else 0

ResponseTime
if {@Closed Date} in {?Begin Date} to {?End Date} then HFWDurNumDateHelpdesk ({CallLog.RecvdDate},{CallLog.ClosedDate})

ClosedDate
Hfwdatetodate({CallLog.ClosedDate})

BeginDate
cdate ({?Begin Date})

EndDate
cdate ({?End Date})
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial