Cannot summarize a running total field

Posted on 2004-11-17
Medium Priority
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

ebolek earned 100 total points
ID: 12607679
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

bdreed35 earned 150 total points
ID: 12607796
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

ID: 12614088
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

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



Expert Comment

ID: 14795031
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 http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21540104.html. ANy help would be hugely appreciated

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

621 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