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