1 Reply Latest reply on Mar 22, 2012 2:20 PM by philmodjunk

    Total Balance within a Portal

    KaityAnczer

      Summary

      Total Balance within a Portal

      Product

      FileMaker Pro

      Version

      11

      Description of the issue

      I have a portal of individual invoices.  I am trying to make a field of the total balance from the individual invoices within each record.  Any thought?  I have tried to make the field a summary and a calculation and seem to be epically failing.  THANKS! :)

      Screen_shot_2012-03-22_at_3.24.40_PM.png

        • 1. Re: Total Balance within a Portal
          philmodjunk

          Note: this part of the forum is intended for posting reports of possible software bugs. The FM Pro Forum is intended for requesting help with FileMaker Pro. (See tabs at top of this screen.)

          From your screen shot, it appears you want a total of the field Bills::Balance_Due

          If you define a field in Patient management as:

          Sum ( Bills::Balance_Due )

          It will report the total fo that field for all records in the portal, provided that the portal is unfiltered.

          You can also define a summary field, sTotalDue as to the total of Balance_Due in the Bills table, then add it to the layout shown and it should report the same exact total.