Dear all,
I have created a report with Running totals, and divided the report by 2 groups.
1st group shows only the name of the codes, whereas 2nd group shows the codes, description, records, percentages, averages etc.
The 1st group footer shows the Sub total of what Group footer 2 values are. The grand total is shown on the Report footer.
The report works well however director asked me if I can take percentages from sub totals instead of grand totals.
Report is based like this
Group 1 - Customer care
Group Footer 2 - Reason Code - Description - jobs - Lenses
Group Footer 2a - Percentages
Group Footer 2b - Averages
Group Footer 1 - Sub total
Report Footer - Grand Total
Currently I am using the following formula to get my percentages
({#DailyCRJob}+{#DailyFOCJob})% DistinctCount({foccredsum.doc_no})
This percentage is taken from Grand total. How can I take the percentage from sub total?
Regards
Jehanzeb