AnsweredAssumed Answered

How to calculate a net amount based on a sub summary

Question asked by eekamouse on Dec 10, 2018
Latest reply on Dec 10, 2018 by eekamouse

I have created a transactional share register with each separate record containing either


1. Shareholder Name and amount shares debited or

2. Shareholder Name and amount shares credited.


There are many different shareholders with transactions.


I want to create a sub summary by shareholder name that when viewed shows me the total shares debited and total shares credited with the net amount appearing.


I have a summary field for both the total shares credited and debited that display correctly but my calculation field which subtracts the credited shares from the debited shares only displays the amount for the entire set of records not by individual shareholder name.


Please advise and thanks so much.