Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Sub Totals

I have a table which shows our monthly allocation to bonds in different countries over the 18 months. I am trying to subtotal the page by month to calculate the total weight in percent for each month...
Show and Tell
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi Anonymous,

The solution given above is a sample. How do you identify the extral cash weigh? According to the screenshot, only the weight column can be used to calculate the weight. And I don't understand the mean"because of a small cash position this will never add to 100%, so I need to calculate what the ex cash position is by multiplying each bond's weight by the total ex cash position." I will apprecite if you share more details. Thanks a lot.

Best Regards,
Angelia


Anonymous's avatar
Anonymous
Not applicable
9 years ago

In order to work out the ex cash position I need to take the total weight 95.73% in the example provided and then divide each country weight by 0.9573 to calculate what each country weight is with the cash percentage removed. In the screen shot provided  I would need to divide 1.38% by 0.9573