To get the weighted average shrinkage value you need dividing the sum of shrinkage by categories to the actual total value:
[D17]=D16/C16