1 Reply Latest reply on Oct 3, 2013 5:00 AM by 5304419582

    Calculating totals on invoices

    AlexLeat

      Title

      Calculating totals on invoices

      Post

           Hello,

           I just began using Filemaker Pro this week, after switching over from Bento. I have gotten my head around most of the controls, but one thing I am struggling with is calculating totals in invoices. (I am inexperienced with databases in general so my terminology may be off)

           I have entered in weight for each of my products, but would like the invoice sheet to calculate and show the total weight for the contents of the invoice, so I can then manually get shipping estimates. It doesnt necessarily need to say the weight on each item line, just at the bottom of the invoice.

            

           Thank you in advance,

           Alex

      Screen_Shot_2013-10-03_at_12.07.10.png

        • 1. Re: Calculating totals on invoices
          5304419582

               Hi Alex,

               What you need to do is create  Caculated field which uses the Sum() Function. It's not clear from what you have shown above is relational (ie that the invoice rows are in separate table, but I'm assuming they are), but basically you would have a calculation in the Invoice table that looks like;

                

               Sum(Invoice_Row::Weight)

                

               Where Invoice_Row is the name of the table Instance of the related row.

                

               I hope that helps.

               James

               --

                

               James Chiswell Jones
               System Architect
               igeek

               W: www.igeek.co.uk
               Twitter: @igeekUK