Brandi,
I think maybe your problem is a timing issue. Try putting the first
line of the formula as whileprintingrecords; Then using the field tree
select the group or summary fields and do whatever math you need to do.
So it should look something like this:
whileprintingrecords;
{#CountChanges} + {#CountWorkOrders}
Also for future reference, while this list does answer question due to
the obvious crossover, I find better answers for crystal related
question in www.tek-tips.com. They are some really sharp Crystal
experts that post there on a regular basis.
Ben Cantatore
Remedy Manager
(914) 457-6209
Emerging Health IT
3 Odell Plaza
Yonkers, New York 10701
>>> [EMAIL PROTECTED] 08/26/08 11:48 AM >>>
**
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"
