what you have created with the formula is a row level division that is summed as you bring it to the vis
the formula should read sum(cost absorption)/sum(kgs)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.