Cannot summarize a running total field

Posted on 2004-11-17
Last Modified: 2009-03-06
I have 2 running total fields. #RT_Students and #RT_Room
I use a formula to do a calculation on the fields @Total = (#RT_Students/#RT_Room)

Now I need to get an average of this formula.

When I try to do this with another running total, the formula does not appear in the list.  When I try to make a formula using the Average() function on the @Total formula I get this error 'This field cannot be summarized'

Is there any way around to achieve what I am trying to do?


Question by:alzoid69
    LVL 10

    Assisted Solution

    You hae t ouse whileprinting records while writing another formula. Evaluation time is the key and make sure that cruystal evaluated the average formula while printing records

    add the rest of the formula here.......

    LVL 28

    Accepted Solution

    Please post the properties of your running totals.
    Field, summary type, evaluation, reset.

    Also, what version of Crystal are you using?
    What fields are you grouping in in your report?

    We can formulate some alternatives, which will vary based upon your running total fields.

    Author Comment

    ebolek:  I tried whileprintingrecords; and I still get the error, I will google for more info.


    Here are the details of my Running Totals and formulas:

    @ScoreXWeight = {C.score} * {C.weight}

    #RT_Score  Field: @ScoreXWeight
                      Type: Sum
                      Evaluate : For each record
                       Reset : On Change of Group

    #RT_Weight  FIeld : weight
                        Type: Sum
                        Evaluate : For each record
                       Reset : On Change of Group

    @FinalTotal  = {#RT_Score}/{#RT_Weight}

    I have 2 groups.  The inner group footer contains  my @FinalTotal. I am trying to get a Average of the @FinalTotal formula to put in my outer group footer.  There could be multiple values for each group so in the outer group footer I want to add an average of the FinalTotal.

    I am using Crystal Reports 9

    Hope this helps.



    Author Comment

    I formulated some alternatives and I used whileprintingrecords; so you both get points.



    Expert Comment

    Sorry to do this as it is probably not the done thing, however I am sure this issue is the same thing as I am currently struggling with and I don't quite get what was done to solve the issue. Can you take a look at my question which is open with 500 points on it as it is so urgent (and frustrating). The link is ANy help would be hugely appreciated

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    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!

    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 …
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    760 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

    8 Experts available now in Live!

    Get 1:1 Help Now