Weighted Average with Caculation
So I've requested weighted averages before and have always been able to do them with Sub Query's. However, I've run into one I don't know how to do. I have a Run Time Column and a Target Ouput column. So I need to Multiply RT * TargetOutput. then I need to use the total/SUM of that column and divide the actual pieces made by the total target pieces.
In the attached image. I need to take A*B to get C. Then D/(summed total of C).