AnsweredAssumed Answered

Sum of records up to a certain date

Question asked by stra21 on Jul 4, 2017
Latest reply on Jul 4, 2017 by stra21

Hello Everyone,


I am fairly new to filemaker and I have what might be a newbie question. I have a couple of thousands of records in a transactions table. This transactions table has a field called "Units IN".Basically I would like to calculate the sum of the first 50 or 100 records for that field. I have achieved this using an executeSQL statement, but I would like to know if there is another way to perform this task. I was thinking of something along the lines of building a custom recursive function.



Thanks in advance