May 4, 201213 yr 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, 201213 yr by ron G
Create an account or sign in to comment