7 Replies Latest reply on Feb 28, 2017 8:41 PM by philmodjunk

    Substotal of specific records

    sam0723

      Hello, i am new to filemaker. i am now working on the calculation of a process.

      For example, there is a table of process and the completion value.

       

      Process         Value

      A                      10

      B                      20

      C                      40

      D                      5

      E                      5

      F                      10

      G                     5

      H                     5

       

      i would like to get the total when i complete several steps. For example, if i complete steps up to B, the calculation field will show 30(10+20).

       

      i could also pass the progress to another person, so his starting point is C, when he finished up to step F, the value should be 60(40+5+5+10).

       

      Is it possible in Filemaker? i am using filemaker 15.

       

      If my description is not clear enough, please let me know, i will explain in more details