Results 1 to 6 of 6
  1. #1
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142

    parts of report that should not change do when one element is changed.

    I have a report that shows all individuals on a shift and how well they do their daily jobs. At the bottom of the report it displays the overall daily average taking into account all the individual scores of the associates.

    Their are three percentage scores that the person gets per day. Performance, Utilization, and efficiency. their are three elements that go into calculating those scores.
    paid time ( time on the clock)
    Earned time ( how long it should have taken to do the work) and
    Productive time ( paid time - lunch, break, and other times no work is being done)

    Performance is earned time / Productive time
    Utilization is productive time / paid time
    Efficiency is performance * utilization

    sorry I had to go through all that but it is important to know where the numbers come from.

    at the bottom of the report is a overall daily average of all associates. The problem I am having is that the first way I set it up is not really giving me a true average of the day. I created three unbound boxes in the report footer and had them simply sum all the individual paid time, earned time, and productive times. I then calculated the daily top three just like i do the individual people. This does not however take into account 0%. the sum ignores the 0.


    Daily performance (=[sumearned]/[sumproductive])
    Daily Utilization (=[sumproductive]/[sumreported])
    Daily Efficiency (=[AvgOfPerformance]*[AvgOfUtilization])
    Click image for larger version. 

Name:	09.JPG 
Views:	15 
Size:	71.9 KB 
ID:	36500
    the report it generates
    Click image for larger version. 

Name:	07.JPG 
Views:	15 
Size:	79.1 KB 
ID:	36502
    I copied the report and changed it to simply average the daily performance and the other two and it not only changed what was displayed in the report footer but in the main report as well.
    what I changed.
    Daily Performance (=[Avg Of AvgOfPerformance])
    Daily Utilization (=[Avg Of AvgOfUtilization])
    Daily Efficiency (=[AvgOfPerformance]*[AvgOfUtilization])
    Click image for larger version. 

Name:	10.JPG 
Views:	15 
Size:	65.3 KB 
ID:	36501
    the report it generates
    Click image for larger version. 

Name:	08.JPG 
Views:	15 
Size:	93.2 KB 
ID:	36503

    For some reason changing the calculations in the report footer also changes the last associates record and throws off the daily average. Namely Vation, Billy goes from 124% to 0%. Why are those calculations being effected?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    It is odd that only Billy's changes.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    Here you go.
    Attached Files Attached Files

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Assume it is Daily Productivity Report. What should I enter into popups?

    Better to reference controls on form for parameter inputs. Review http://allenbrowne.com/ser-62.html
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    chriswrcg is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2018
    Location
    Philippines
    Posts
    142
    yes, daily productivity report
    first pop up is FAU
    second is 12/7
    third is 12/7

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Used those inputs, open report in PrintPreview. Calc results are not what you posted but Billy's does calculate. So this report does not have the changes you describe?

    I don't understand why you would want to reference a control in the FullName header in a control in Report footer.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Report name changed
    By ashu.doc in forum Reports
    Replies: 7
    Last Post: 09-18-2012, 08:01 AM
  2. Replies: 3
    Last Post: 08-02-2012, 11:37 AM
  3. Replies: 8
    Last Post: 05-16-2012, 10:49 AM
  4. Shading only parts of a report
    By coach32 in forum Reports
    Replies: 1
    Last Post: 11-22-2011, 02:26 AM
  5. Replies: 3
    Last Post: 07-08-2010, 01:47 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums