1 Reply Latest reply on May 10, 2016 9:43 AM by TSPigeon

    Struggling with calculations

    mep.kevin545

      I am new to file maker pro 14.  My issue is I am creating a database.  I am trying to list the quantity in the field and at the very bottom in total quantity give a sum total of all of them for example;  I have listed in the quantity box the numbers 1 and 2.  I am trying to calculate them in the  total calculation box getting the sum of 3.  How do I do this?

        • 1. Re: Struggling with calculations
          TSPigeon

          mep.kevin545

           

          Thank you for your post!

           

          The Summary Fields can give you a total based off of a Field across multiple records. If you want a Total based off multiple fields on the same record you might check Calculated Fields instead.

           

          If they are all number fields you might try something similar to [Field1 + Field2 + Field3], which is probably the most basic (and I'm not a developer so probably not the best way).

           

          I am also going to move this thread from the Community Feedback which is specifically for input on the Community itself to the Discussions Space where you should receive more views and potentially more advice!

           

          TSPigeon

          FileMaker, Inc.