Skip to Content
0
Former Member
Nov 28, 2008 at 04:29 PM

Percentage from Sub total

26 Views

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