AnsweredAssumed Answered

Substotal of specific records

Question asked by sam0723 on Feb 26, 2017
Latest reply on Feb 28, 2017 by philmodjunk

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