Good Morning. I have a text table with rows of monthly data for each provider. Each row has a calculated average of Total Hours over Standard Monthly Hours. My problem comes with the total row average. The number given (42% for the first provider) is the average of the averages above it and not an average of the totals. The average of averages is 1-3% lower than it should be. How can I make that total line average calculate with the totaled hour values (290/660 should equal 44% for the first provider)? Thanks for in advance for your help!
Hi Susan,
When trying to open the workbook it tries to execute a stored procedure and hence I can't open it. Can you share formula you are using to calculate %Direct?
If you are simply doing Total Hours/Standard Hours, try changing it to SUM(Total Hours)/SUM(Standard Hours).
Subodh.
