# Cannot summarize a running total field

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?

Thanks

Allan
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
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

Formula
whileprintingrecords;
add the rest of the formula here.......

Regards
Emre
0
Commented:
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.
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:

bdreed35:

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.

Al

0
Author Commented:
I formulated some alternatives and I used whileprintingrecords; so you both get points.

Thanks

Al
0
Commented:
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
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.