Average of Daily Distinct Counts

Posted on 2011-10-17
Last Modified: 2012-06-27
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?
Question by:AverageJoeChef
    LVL 77

    Accepted Solution

    You should use 3 formula fields to produce this value.

    In the report header you initialise a couiple of variables.

    numbervar totaldailycount:=0;
    numbervar daycount:=0;

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

    numbervar totaldailycount;
    numbervar daycount;
    totaldailycount:= totaldailycount + {your distinct group total field here};

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

    numbervar totaldailycount;
    numbervar daycount;


    Author Comment

    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...


    any tips?
    LVL 77

    Assisted Solution

    I suspect you have dropped one of the ; line terminators in making your mods..
    LVL 100

    Expert Comment

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now