A
Alex Martinez
I have a report that looks like this:
Auditor # of Policies Days Worked Average Per Day Average
Per Week (Based on 5 days worked)
James Smith 32 5 6.4
32.0
John Doe 20 5 4.0
20.0
Jane Smith 34 5 6.8
34.0
Mary Shad 32 5 6.4
32.0
Total
The first table I use called "Production" the fields are 'Auditor' & 'Days
Worked'. The second table called "Inventory" contains field called
'Auditors' & '# of Policies'. Both tables are join via 'Auditors' in the
Auditors footer I able to get the above without a problem, but geting the
Days Worked, Average Per Day/ & eek I get the wrong totals. Now in the
detail section let's use James Smith as an example - He has 32 policies the
days worked refers to out of the 32 policies he worked 4 days, which you
will see 4 days 32 times in the detail section. Average Per Day is a
caluculated field 32 polices divide by 4 days worked. The Average Per Week
is calulated as 5 days multiply by 6.4 Average Per Day. I can get the
policies total correct, but days worked total adds up all of the 32
policies. The total should be 20 days worked, The average per day total
should be 23.6, The Average Per week should be 118. The average Per Day &
Average Per Week are calculated fields and I seem to be unable to get the
correct totals. Any tips or help will be appreciated. Thank you.
Auditor # of Policies Days Worked Average Per Day Average
Per Week (Based on 5 days worked)
James Smith 32 5 6.4
32.0
John Doe 20 5 4.0
20.0
Jane Smith 34 5 6.8
34.0
Mary Shad 32 5 6.4
32.0
Total
The first table I use called "Production" the fields are 'Auditor' & 'Days
Worked'. The second table called "Inventory" contains field called
'Auditors' & '# of Policies'. Both tables are join via 'Auditors' in the
Auditors footer I able to get the above without a problem, but geting the
Days Worked, Average Per Day/ & eek I get the wrong totals. Now in the
detail section let's use James Smith as an example - He has 32 policies the
days worked refers to out of the 32 policies he worked 4 days, which you
will see 4 days 32 times in the detail section. Average Per Day is a
caluculated field 32 polices divide by 4 days worked. The Average Per Week
is calulated as 5 days multiply by 6.4 Average Per Day. I can get the
policies total correct, but days worked total adds up all of the 32
policies. The total should be 20 days worked, The average per day total
should be 23.6, The Average Per week should be 118. The average Per Day &
Average Per Week are calculated fields and I seem to be unable to get the
correct totals. Any tips or help will be appreciated. Thank you.