AnsweredAssumed Answered

Merge and Sum Functions

Question asked by JustenBeasley on Jun 9, 2014
Latest reply on Jun 16, 2014 by JustenBeasley

Title

Merge and Sum Functions

Post

I am looking for a way in filemaker database for it to look at multiple fields and if they match sum and merge the fields. I want it to merge the records if both Cards & Address field are the same. So it will use both Address and Cards as factors of merge & Sum. Example of the Table before and after the merge & Sum are attached. If you see the only one it merged would be the one with the Same Address and Same Card and then it merge and sum the ones that meet that criteria. Is this possible?

      

      

Screen_Shot_2014-06-09_at_8.34.11_AM.png

Outcomes