Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing Summaries 1

Status
Not open for further replies.

pineisland99

Instructor
Feb 13, 2007
22
0
0
US
I have the below formula in my group footers - It basically adds a few sums together -

I want to add all if its results together in the report footer -

When I try to use the Summarize function, it doesn't show/allow me to pick this formula as a 'field to summarize'

Sum ({@ProcCount}, {TRACKING_FILE.f453#processor_name})+Sum ({@ClosedCount}, {TRACKING_FILE.f453#processor_name})+Sum ({@UwCount}, {TRACKING_FILE.f453#processor_name})

Thank You!
 
Create a separate formula:

Sum ({@ProcCount})+Sum ({@ClosedCount})+Sum ({@UwCount})

-LB
 
Thank You,

New formula was created with your info. plus some added code and placed on report footer;

(Sum ({@ProcCount})+Sum ({@ClosedCount})+Sum ({@UwCount}))-Sum ({@ClosedDateCount})

Thanks Again!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top