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

Cross tab percent total

Status
Not open for further replies.

redsand23

Technical User
Feb 22, 2002
77
US
Hello all I am running Crystal 9 and trying to perform a cross tab that will give me the actual % total for a cross tab.

200401 200402 200403 200404
0-1 DAY LEAD TIME 94.12 91.93 93.29 90.13
ontime 5,311 5,458 6,358 5,577
total rec 5,643 5,937 6,815 6,188
2-7 DAY LEAD TIME 87.01 89.79 85.85 78.89
ontime 1,527 1,758 1,760 1,573
total rec 1,755 1,958 2,050 1,994

For example my 200401 total should be 92.43% however what it is doing is taking 94.12 + 87.01 and dividing by 2 to give me 90.56

Is there a way in the total to get to add all of the ontime and add the total rec then divide to give me the true %.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top