Percentage Formula Question

[tinmar]

Hi,

Using Crystal 8.5 to an Oracle db, I'm trying to get a percentage figure of the amount of ACW time in Handle Time (Where Handle time is made up of ACW time and two other entities.)

Handle Time and ACW are calculated as follows:
Handle Time = Sum({@Fields - HandleTime}, {@Field - SKL_DATE}, "daily") / 86400;

ACW Time = Sum({@Field - ACW_TIME}, {@CenterGroup}) / 86400;

And the calculation I thought would be right is:
[Its result doesn't match up with manual checking of a percentage.]

whileprintingrecords;
Numbervar Dur1 := Sum({@Field - ACW_TIME}, {@CenterGroup}) / 86400;
Numbervar Dur2 := Sum({@Fields - HandleTime}, {@CenterGroup}) / 86400;

numbervar Dur = (Dur1/Dur2);

ToText(Dur)

Can anyone point out where I'm going wrong?

Thanks for any help
Mike

 

[smcnulty2000]

What happens when you write the formula this way?


whileprintingrecords;
Numbervar Dur1 := Sum({@Field - ACW_TIME}, {@CenterGroup});
Numbervar Dur2 := Sum({@Fields - HandleTime}, {@CenterGroup});

numbervar Dur = (Dur1/Dur2);

ToText(Dur)


Scott.