AnsweredAssumed Answered

sub summary when sorted by field not working

Question asked by BorisKamp on May 19, 2015
Latest reply on Jun 9, 2015 by BorisKamp

Title

sub summary when sorted by field not working

Post

Hi guys,

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?

Thanks!

 

Screenshot_2015-05-19_09.15.16.png

Outcomes