Percentages Total

Z

zufie

I have a Report that contains a column of percentages (one at the end
of each of the six rows).

I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.

However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),

He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]

How can I get this to accurately add these percentages?!

Thanks,
John
 
K

KARL DEWEY

Do not total the percentages. Sum the numbers used to derive the
percentages and then do a percent.
 
Z

zufie

Do not total the percentages.   Sum the numbers used to derive the
percentages and then do a percent.

--
Build a little, test a little.



zufie said:
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
.- Hide quoted text -

- Show quoted text -

Good idea. However, the end users want a percentage at the end of each
row. I will check with the users and see if this is still important.
Thank you. Zuf
 
K

KARL DEWEY

I did not say to remove the percentage displayed at the end of each row.
I said to not total those percentages but use the raw data for total percent.
--
Build a little, test a little.


zufie said:
Do not total the percentages. Sum the numbers used to derive the
percentages and then do a percent.

--
Build a little, test a little.



zufie said:
I have a Report that contains a column of percentages (one at the end
of each of the six rows).
I have the Percentages Total textbox at the bottom of this column that
is to add each of these percentages so that the Percentages Total
equals 100%.
However, when the Percentages Total is slightly under 100% OR slightly
over 100% the Percentages Total textbox still returns 100%. (e.g. 99,
99.9, 99.98, 100.1),
He is the Control Source for the Percentages Total textbox:
=[Percent less than high school]+[Percent High School Graduate]+
[Percent Some College/Voc/Trade School]+[Percent Trade/Voc Graduate]+
[Percent College Graduate]+[Percent Graduate Degrees]+[Percent Other
Education]+[Percent No Response Education]
How can I get this to accurately add these percentages?!
Thanks,
John
.- Hide quoted text -

- Show quoted text -

Good idea. However, the end users want a percentage at the end of each
row. I will check with the users and see if this is still important.
Thank you. Zuf
.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top