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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"