Percentage in a report

[JC]

I have a summary report for which I need percentages.
Field3 is the file number, Field64 is the number of pages
printed for each file. These sums appear in the Field3
footer, with the detail portion of the report being
hidden.
There are various file numbers, but one file is 8888 and
the other is 888888, for which I have a total of pages
for each file. I also have various file number, that are
numerically less than 8888 and/or 88888. What I need is
the following:
- a total of pages printed for the files that are not
8888 or 888888; and
- a percentage of pages printed for these files and a
percentage for the files 8888 and/or 888888
I have put a field in the report footer to try to do this
but I always end up with an error
Does anyone have any idea how I can go about getting my
percentages for the files that are not 8888 and/or 888888
compared to the other file numbers?
I would greatly appreciate any help I can get
Thanks
JC

 

[Marshall Barton]

I have a summary report for which I need percentages.
Field3 is the file number, Field64 is the number of pages
printed for each file. These sums appear in the Field3
footer, with the detail portion of the report being
hidden.
There are various file numbers, but one file is 8888 and
the other is 888888, for which I have a total of pages
for each file. I also have various file number, that are
numerically less than 8888 and/or 88888. What I need is
the following:
- a total of pages printed for the files that are not
8888 or 888888; and
- a percentage of pages printed for these files and a
percentage for the files 8888 and/or 888888
I have put a field in the report footer to try to do this
but I always end up with an error
Does anyone have any idea how I can go about getting my
percentages for the files that are not 8888 and/or 888888
compared to the other file numbers?

Use a text box in the report footer section and set its
expression to something like:

=Sum(IIf(Field3 <> 8888 And Field3 <> 888888, Field64, 0)