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

    Substotal of specific records


      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