Scenario: We quality score work in our business to ensure this is updated correctly and we give each 'engineer' a mark out of 5 each week. Currently we are able to work out the percentage each week of a given score i.e. 5 out of 5 gives you 100%.
What we want to work out is how to count up this by month but to exclude the week where scoring isn't applicable.
For example: Sharepoint 2010 List - Quality Scoring
Single Text Cells: WK1: 100% (SP Value 5) WK2: N/A (SP Value 0) WK3: 100% (SP Value 5) WK4: N/A (SP Value 0)
When i do a calculated column to work out the percentage we are using formula =(WK1+WK2+WK3+WK4)/20 this gives us the result : 50%
What I'm struggling to understand is how can I not count up the N/A or 0 cell each week? In theory that would mean where the above is 100% for two of the four weeks you would achieve 100%.
Can anyone help me with the formula? I'm sure this is something fairly simple but I'm missing it.....