Fireguy2014
New Member
- Joined
- Sep 21, 2014
- Messages
- 5
Hi. I am trying to calculate averages for some Team Members production rates for each shift on a weekly basis. The problem I am having is that there are some shifts where they are in other functions and therefore have 0 production quantities. I want to remove any value of 0 from my averages. I only want to calculate shifts where they have been in production.
For example:
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thank you very much in advance for any suggestions.
Fireguy
For example:
Last Name | First name | User Name | Badge # | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Weekly | Average |
Smith | Gerry | 860 | 0 | 952 | 757 | 1005 | 0 | 3574 | 854.50 | ||
Brand | Kimberly | 700 | 655 | 825 | 693 | 987 | 0 | 3860 | 835.00 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thank you very much in advance for any suggestions.
Fireguy