Portal field summary

[ron G]

I am using FM 12 Advanced.

I have 2 tables: Members and Dues

On Members I have a portal based on Dues.

All I want is a summary field (in the upper right corner) that shows the total of the over/under amount field.

I tried a summary field. Nope.

I tried a calculated field. Nope

Surely there is a simple way to do this. It seems like it should be quick and simple but I am stumped.

Can someone 'turn on the light' for me? (No, I can't use a sub-summary report. I just want to total a field in a portal)

Thanks

The solution is to put the Sum calculated field in the Members Table... Not Dues... Which makes perfect sense since the summation is of the Members Dues record... duh....

Edited May 4, 2012 by ron G