is your report based on a query? I would set up a query, and have it
be based on the one table, as well as create a column named Average.
The formula for this column should be:
Average: [Units]/[Hours]
Set the format of this field to Percent and it should work.
On Dec 8, 8:10 am, "Kevin" <kpschroe...@gmail.com> wrote:
> I am trying to create a DB that calculates employee production averages
> on a report. My table which is called 't_production' includes the
> following fields:
>
> ID, Date, Category, Goal, Units, Hours
>
> Information is entered into this table via a form called
> 'f_production'.
>
> I have then created a report called 'r_production' which includes the
> following fields:
>
> ID, Date, Category, Goal, Units, Hours, Average
>
> In the Average field I've experimented with various formulas however
> my data always comes back incorrect. To calculate my average I'm
> simply taking (Units/Hours)*10.
> For example:
>
> ID Date Category Goal Units Hours Average
> 0001 12/05/06 Hard Home 90 80 8 100
>
> (80 Units/8Hours)*10= 100%
>
> When I begin to add multiple records the data seems to get lumped
> together into one sum and the averages do not correspond. For Example:
>
> ID Date Category Goal Units Hours Average
> 0001 12/05/06 Hard Home 100 800 8 135
> 0001 12/05/06 Shoes 65 550 6 135
> 0002 12/05/06 Soft Home 75 780 8 135
> 0003 12/05/06 Hard Home 95 1000 4 135
>
> Can someone point me in the right direction? Is there a formula that I
> can include in the Average field on my report that will fix this? Am I
> going about this all wrong? Should I be calculating the average within
> my table first? If so, how do I do that?
|
Similar Threads
