Calculating a Percentage

[Alaska1]

I have a report with a subform that totals the number of ts processed and then in the report a report header that totals the number of errors. I need to come up with a percentage from the two totals. I have created a text box and added the formula.



=[SumErrors]/Forms![Sum of TimeSheets Processed]![SumOfTimesheets in Package]

The forumla. Any suggestions?

Thank you!

[RuralGuy]

Are you trying to refer to your Report or SubReport or some Form somewhere?

[Alaska1]

I have a report with a subform that totals the number of ts processed and then in the report a report header that totals the number of errors. I need to come up with a percentage from the two totals. I have created a text box and added the formula.

=[SumErrors]/Forms![Sum of TimeSheets Processed]![SumOfTimesheets in Package]

The forumla. Any suggestions?

Thank you!

The Sum of errors is in a report where the sum of timesheets processed is in a form that was added as subform to the report.

[RuralGuy]

You do not go through the Forms collection for the data. You can reference the control directly
=SumErrors/YourSubReportControlName.[SumOfTimesheets in Package]
...remembering that the SubReportControlName need not be the same as the SubReport it is displaying.

[Alaska1]

You do not go through the Forms collection for the data. You can reference the control directly
=SumErrors/YourSubReportControlName.[SumOfTimesheets in Package]
...remembering that the SubReportControlName need not be the same as the SubReport it is displaying.

I am still having a problem with this calculation. I am using the subreportcontrolname. I have checked to make sure I am using the correct subreport name. I called it TimesheetReport. The other field I am trying to divide by is called SumErrors but the control source is =Sum([CountOfTimeSheetErrors]) which is in the main report

Not sure why I am not able to come up with a value.

=SumErrors/[Timesheet Report].[SumOfTimesheets in Package]

[RuralGuy]

The items in RED are not the same!

I am still having a problem with this calculation. I am using the subreportcontrolname. I have checked to make sure I am using the correct subreport name. I called it TimesheetReport. The other field I am trying to divide by is called SumErrors but the control source is =Sum([CountOfTimeSheetErrors]) which is in the main report

Not sure why I am not able to come up with a value.

=SumErrors/[Timesheet Report].[SumOfTimesheets in Package]

[Alaska1]

The items in RED are not the same!

That was an error. I did not have a space bewtween Timesheet Report in my forumla.

Thank you for all your help.

[RuralGuy]

As a test I would start with:
=SumErrors
...and see what I got and then...
=[TimesheetReport].[SumOfTimesheets in Package]
...and make sure the reference is correct and the value is correct.