how to calculate average percentage?

[nightelfdruidhunter]

Hi i'm trying to get an average of percentage on my report.
and this is what I pupolated so far.

State # of shipping % of shipping Ave. %
----- ------------- ------------- ----------
NY 4010 40%
NJ 1063 11%
CT 832 8%
TN 2202 22%
CA 2008 20%
----- ----------- ---------- ---------
Total 10115 100% 100%

Dose anyone can help me to write a formula to calculate Average %?
Thank you.

 

[Turkbear]

Hi,
Average % of what?







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[nightelfdruidhunter]

Thanks Turkbear.
Average % of "% of shipping" (3rd column) for each state (1st column).
Thanks again.

 

[lbass]

The problem is that you are not showing what it is you are averaging, which I guess are records at the detail level. Please show a sample of detail records and then show the average you would expect from that.

-LB

 

[nightelfdruidhunter]

Sorry for not making it clear.
Actually, the data displayed in my origianl posting is a crosstab in the report footer section. There's no data in detail section.

What I am working on w/ this report is calculate average shipping percentage for shipped items (2nd column) by State.

"% of shipping" is calculated by (# of shipping/Total# of shipping)*100 for each state.
Ex.) (4010/10115)*100 for NY.

Thank you agian.

 

[lbass]

You are leaving out significant information, e.g., that this is a crosstab. It is still unclear what you are asking help on. Do you already have the % of shipping calculation working? What is the average you expect to see? What is it based on?

-LB