Summarize Percents

[dcanfield]

Hi,

I have a report that groups and summarizes sales by region.

Sample data looks like this:

Percent
of Total
Region $ Sales Sales

Region A $ 1000 20%
Region B $ 1500 30%
Region C $ 2500 50%

Total: $ 5000



I can get the above information to work correctly in CR (Version 10), but I would also like to have it summarize the percentage, and display that as well.



Thus the report would look like this:

Percent
of Total
Region $ Sales Sales

Region A $ 1000 20%
Region B $ 1500 30%
Region C $ 2500 50%

Total: $ 5000 100%

Is it possible to do this?

Thanks for your assistance.

David

 

[synapsevampire]

Since a total percent of total sales is ALWAYS 100%, you should just use a text object.

You didn't state how you created these summary percentages.

In general you'd want the 3 formula method:

Group header formula:
whileprintingrecords;
numbervar MyTotal:=0

Details formula:
whileprintingrecords;
numbervar MyTotal:=MyToal+<your percentage summary formula>

Group footer formula:
whileprintingrecords;
numbervar MyTotal

-k