[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 640
  • Last Modified:

Average of Daily Distinct Counts

Greetings! I am looking for some assistance in finding the average of a several group distinct counts.  What I have is this:

1.) Report is grouped in ascending order, section printed for each day.  Each day I have several transaction which I run a summary of distinct count.  I am looking for a value in the report footer which shows the AVERAGE daily count for the reporting period.    Any tips?
0
AverageJoeChef
Asked:
AverageJoeChef
  • 2
2 Solutions
 
peter57rCommented:
You should use 3 formula fields to produce this value.

In the report header you initialise a couiple of variables.

//@init
whileprintingrecords;
numbervar totaldailycount:=0;
numbervar daycount:=0;
""

In the daily group footer you add to the vriables..

//@addtotals
whileprintingrecords;
numbervar totaldailycount;
numbervar daycount;
totaldailycount:= totaldailycount + {your distinct group total field here};
daycount:=daycount+1;
""

In the report footer calculate the average and display it...

//@avgcount
whileprintingrecords;
numbervar totaldailycount;
numbervar daycount;
totaldailycount/daycount





0
 
AverageJoeChefAuthor Commented:
Thanks!  So far, in the second section, I'm getting an error stating that the following does not appear to be part of the formula...

daycount:=daycount+1;
""

any tips?
0
 
peter57rCommented:
I suspect you have dropped one of the ; line terminators in making your mods..
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now