AnsweredAssumed Answered

Running total for common field

Question asked by ingwe on Feb 8, 2017
Latest reply on Feb 9, 2017 by user19752

Hello. First of all I am a beginner to filemaker. I hope you guys can help me. I am trying to create a field that will keep a running total on the amount of another field. For example:

 

Database with 1000 records. 200 records are type A, 200 are type B etc.....

 

Product name: X  (name field)

Product type:  A    (name field)

Product price:10 (variable)   (number field)

Running total:  (would keep a running total of the amount all product A types are worth)

 

Product name: X  (name field)

Product type:  B    (name field)

Product price:10 (variable)   (number field)

Running total:  (would keep a running total of the amount all product B types are worth)

 

I hope I have explained this well enough. Could anyone give me a calculation (or something else) to make running total work? Thank you

Outcomes