I want to figure out by date and employee a precentage from a number of pieces they have looked at vs how many are actually good. Here are my column headings in my pivot table
Date, Employee#, total pieces, total good Pieces
the formula should be as simple as (total good pieces)/(total pieces) = precent good by day. However, I get weired percentages going over 100% which just can't be for every day there is less good pieces than there are total pieces per employee.
Date, Employee#, total pieces, total good Pieces
the formula should be as simple as (total good pieces)/(total pieces) = precent good by day. However, I get weired percentages going over 100% which just can't be for every day there is less good pieces than there are total pieces per employee.
