Percent of Grand Total by Group

[Guest]

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

 

[Wolfgang Kais]

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.

 

[Guest]

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

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.

 

[Wolfgang Kais]

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

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

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.

 

[Guest]

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.

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

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

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.

 

[Wolfgang Kais]

Hello 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.

Yes, you are right. I forgot to mention that option. ;-)