Skip to Content
0
Former Member
Jan 09, 2009 at 10:41 PM

Need Some Help in creating chart description is long thanks for ur time.

16 Views

Hi, I was asked to create a chart for an existing report which is Average number of days open versus Profit Center.

I need to calculate Average number of days open as a sum of {command.Days_Opened}/Record Count.

Record Count = number of records with days open 0 in a group

I created a running total name Evalution and put it in details with formulae

whileprintingrecords;

Numbervar i;

if (command.days_open) 0 then

i := i+1;

else

i

In group headder i put @reset with the following syntax: whileprintingrecords; Numbervar i := 0;

in Group footer again Display with formulae whileprintingrecords; Numbervar i;

so i finally got avg. number of days open as Sum of {command.Days_Open}/@dispaly

tested the formule and is working well.

But the problem is this formulae doesnt work in chart. How can i resolve this problem