I have what seems like a simple problem, but I don't have the knowledge to achieve what I want.
My data is such that I have detail lines for scrap joined with summary lines for quantity complete. In a table I can create a percentage column for the detail, but because I'm summing and averaging in separate columns I can't get the total percentage right.
In the attached example all the numbers show correctly, but the total percentage should be 2.41, not 4. Can you impart your knowledge please?