sub summary when sorted by field not working
I have this layout (see attachment), however, the total investment percentages (8% as seen) do not work in my sub summary layout part.
What I want this field to be is the percentage compared to the total worth of the fund (vermogen, $2.000.000) see the left bottom.
so $41.820 / $2.000.000 = 2,09% for the first sub summary.
All the fields seen come from one table called "Properties" the percentage field is as following:
Summary Total Investment % = Summary Total Investment / AWF III Vermogen
Summary Total Investment = Total of PurchaseInfoFinalInvestment (total investment for a property)
I guess I'll need a TO to achieve this, I tried but did not get it to work.
What am I doing wrong here?