Percent total 101%!

[zufie]

I have a Percentage total of 101% on a report.

There are two rows in the report that each return 1%. This added to
another row of 98% (98% + 1% + 1% = 101%)

Do I need to change these two 1% via rounding/decimals?

If so, how do I do this?

But do I have to change this on the REPORT OR on the SUBFORM that
feeds only numbers (values) into the report?

I tried both to no avail!?

The subform returns percentage values containing one decimal. (e.g.
1.3%)

The report returns whole percentage values containing no decimals
(e.g. 1%)

The report percentage total shold always show 100% AS IT DOES, but the
values listed above this, on the report are 1%, 1%, 98% , which totals
101%!?

Here is the REPORT equation or code for each row returning 1%:

Control Source: =([Asian Total]/[Race Total])
Format: Percent
Decimals: 0
==============================
Control Source: =([AmericanIndian/AlaskaNative Total]/[Race Total])
Format: Percent
Decimals: 0
==============================================

Here is the SUBFORM equation or code for each row returning 1%:

=IIf([Race Total]=0,0,[Asian Total]/[Race Total])*100
Format: no format chosen
Decimals: 2
==============================================
=IIf([Race Total]=0,0,[American Indian/Alaska Native Total]/[Race
Total])*100
Format: no format chosen
Decimals: 2

Thanks !,

Zufie/John

 

[KARL DEWEY]

Do I need to change these two 1% via rounding/decimals?
Do not sum percentages. Add the base number and then calculate the
percentage.