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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Sum Percentages

Status
Not open for further replies.

mischief911

Technical User
Jan 14, 2002
21
US
HELP!
Using CR v10

I have tried to sum a formula that calculate the percentage of dollars in each Group - this formula is located GF 2. I need to accumulate (sum) these percentages calculated by the formula ({@O/S % of Total} to display in GF 1 as the Grand Total of the accumulated percentages.

I have tried to create a formula to set the variable to accumulate the %'s and then another formula to place in the GF 1 to display the variable with the accumulation and nuttin' seems to work.

What am I missing?
 
You should always share the contents of your formulas in posts. You should be able to use three formulas:

//{@reset} to be placed in GH#1:
whileprintingrecords;
numbervar addpc;
if not inrepeatedgroupheader then
addpc := 0;

//{@accum} to be placed in GF#2}:
whileprintingrecords;
numbervar addpc := addpc + {@yourpercentcalc};

//{@displ} to be placed in GF#1:
whileprintingrecords;
numbervar addpc;

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top