Re: Report..

Billy Huddleston ( (no email) )
Thu, 10 Apr 1997 20:50:15 -0400

That took care of it.. How would I do is so that It would display in Hours
& Minutes and Not screew up when there is 0 Hours.. I'm not up to snuff
yeat with IDC or SQL ..

----------
> From: Dale E. Reed Jr. <daler@comtch.iea.com>
> To: emerald@emerald.iea.com
> Subject: Re: Report..
> Date: Thursday, April 10, 1997 8:14 PM
>
> On Thu, 10 Apr 1997, Billy Huddleston wrote:
>
> > OKay.. So good so far.. I have it running... One Problem.. The output
> > doesn't match with what emerald says when it reports total time.. It
seams
> > to be related to the fact that emerald is rounding each session the
adding
> > the time up.. But The IDC simply ads The sessions then rounds.. Makes
for
> > an inconsistent match.. How can this be fixed?
>
> Emerald uses per minute billing. My guess is they are doing accumulative
> per second billing:
>
> Sum( (AcctSessionTime/60) +1)
>
> not
>
> Sum(AcctSessionTime/60) or Sum(AcctSessionTime)/60
>
> Dale
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com