Solved

# Cannot summarize a running total field

Posted on 2004-11-17
3,387 Views
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
0
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

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

Regards
Emre
0

LVL 28

Accepted Solution

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

Author Comment

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 Comment

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

Thanks

Al
0

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

## Featured Post

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 (https://www.experts-exchange.com/articles/28474/The-Case-of-a-Missing-Mobile-Phone.html)". 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 (https://www.paessler.com/prtg) 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…

#### Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!