Totaling on an Annual Report
I am in the home stretch!
I have a report generated from a simple find script called Annual Profits. I click the RunAnnual button, fill the appropriate Year in the Custom Dialog and my script produces a report of all the Projects from that year. The report has a few calculated fields including ProjectTotalProfit. I would like to add all the ProjectTotalProfit fields found into a single AnnualTotalProfit and display it on the report.
All the searching I have done leads me in circles around Sub-summary but I don't understand how to make it do the math on the report.