I don't think you can do a summary there - you need to use a running total
instead.
HTH
Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED]
Brandi Barbour <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)"
<arslist@ARSLIST.ORG>
08/26/2008 11:48 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
[ARSLIST] Crystal Report Calculation Question
**
All,
I am trying to calculate (add together) a formula field that is in group
footer 2.
For some reason i can not do a summary of the formula field because it
does not come up in the fields to be summarized.
The formula field is defined as Hours and has a formula of :
{CSC_SES3_WOI_WII_Work_Order_Join.csc_dec_estimated_hours} *
DistinctCount ({CSC_SES3_WOI_WII_Work_Order_Join.csc_dec_estimated_hours},
{CSC_SES3_WOI_WII_Work_Order_Join.Summary})
This works fine.
However now i need to add all the values from this formula and place it in
the group footer 1 section so it will calculate all the time spent for all
the entries under Group 1.
Can not seem to find how to do this.
I have tried just adding the same formula field to the Group 1 footer
section but that just gives me the last entry in group 2 footer and does
not add all the sections together.
Any ideas?
Crystal Reports XI
ARS 7.1.0
ITSM 7.0.3
Thanks,
Brandi __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
