Percent of Grand Total by Group

K

Karin

Hi,
I have a report with a group for each manager and under that for billed or
unbilled projects. The billed projects total in the billed footer.

In the report footer I have a grand total of billed projects.

I would like to put in the billed footer of each manager the percent of the
total billed from the report footer. What is the best way to accomplish
this?

TIA
 
K

Karin

Thank you, but it always comes up with 0%. Perhaps because in the billed
footer the report footer total has not been generated?

Wolfgang Kais said:
Hello Karin.
I have a report with a group for each manager and under that for
billed or unbilled projects. The billed projects total in the
billed footer.

In the report footer I have a grand total of billed projects.

I would like to put in the billed footer of each manager the
percent of the total billed from the report footer.
What is the best way to accomplish this?

Suppose that the textbox for the billed projects total in the billed
footer is named [billed projects total] and the grand total of billed
projects in the report footer is named [billed projects grand total].
Create a new textbox in the billed footer and change it's control
source to =[billed projects total]/[billed projects grand total].
Also change it's format property to percentage and set the decimal
places appropriately.
 
K

Karin

Thank you -- I don't know what I was doing wrong, but it's working now.
Perhaps I just needed to start fresh in the morning. :)

Wolfgang Kais said:
Hello Karin.

No. When using the report wizard to display a total per group and
also calculating the percentage, the wizard does exactly the same.
Try creating a report using the wizard and verify the result.

Therefore: Check the names of the controls or manually create the
formula using the expression builder.
And also verify the data...

--
Regards,
Wolfgang


Karin said:
Thank you, but it always comes up with 0%. Perhaps because in the billed
footer the report footer total has not been generated?

Wolfgang Kais said:
Hello Karin.

Karin wrote:
I have a report with a group for each manager and under that for
billed or unbilled projects. The billed projects total in the
billed footer.

In the report footer I have a grand total of billed projects.

I would like to put in the billed footer of each manager the
percent of the total billed from the report footer.
What is the best way to accomplish this?

Suppose that the textbox for the billed projects total in the billed
footer is named [billed projects total] and the grand total of billed
projects in the report footer is named [billed projects grand total].
Create a new textbox in the billed footer and change it's control
source to =[billed projects total]/[billed projects grand total].
Also change it's format property to percentage and set the decimal
places appropriately.
 

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